Solutions for removing duplicate column

[colling]

Hi everyone!

I hope you get a nice day today.

I post this question for solving problems what I faced.

When importing duplicated column in alteryx, sequence numbers are automatically allocated.

For example

in excel

	John	John
1	A	D
2	B	E
3	C	F

in Alteryx

	John	John2
1	A	D
2	B	E
3	C	F

It doesn't matter when I just use those format, but if I use 'transpose' component duplicate column become completely different data. I want to recognize two headers with the same name as homogeneous data, is there any solution?

Output

	Name	Value
1	John	A
2	John	B
3	John	C
4	John2	D
5	John2	E
6	John2	F

Target output

	Name	Value
1	John	A
2	John	B
3	John	C
4	John	D
5	John	E
6	John	F

[atcodedog05]

Hi @colling 

Use a formula like this after transposing.

TrimRight([Name],"123456789")

Hope this helps : )

[messi007]

@colling,

Please see below

Attached the workflow,

Regards,