removing duplicate values within a row

Hi,

I’m convinced there is a simple solution to this, but I can’t work it out and I can’t find any topic which quite covers it.

I have data as follows:

A 1 2 3 3

B 4 2 2 5

C 6 3 2 6

I would like to keep the format the same but remove all the duplicate values within a row, so it would look like this:

A 1 2 3

B 4 2 5

C 6 3 2

So my plan was to split columns 2-4 on to different rows, remove the duplicate rows then put it back together again. However I can’t figure out a node or group of nodes which will split columns 2-4 out on to different rows grouped by the letter e.g.

A 1

A 2

A 3

A 3…etc

Perhaps there’s a better way of doing this? If anyone can help I would be very grateful.

Thanks,

Sian