Numbering Duplicate Fields

[JakeRysdon]

Hello,

Can anyone help make this:

12345	2019-11-30 13:14:00	DR
12345	2019-11-21 13:31:00	DR
12345	2019-11-12 07:58:00	ON
12345	2019-11-30 10:48:00	ON

Look like this:

Number	DR	DR	ON	ON
12345	2019-11-30 13:14:00	2019-11-21 13:31:00	2019-11-12 07:58:00	2019-11-30 10:48:00

I am struggling to get the fields to duplicate like above. I also tried to put numbers on the duplicate fields though I failed to find a workable solution. Any ideas would be appreciated. 

Thanks

[JosephSerpis · Accepted solution]

Hi @JakeRysdon I mocked up a workflow that produces your output. Alteryx be default does not allow duplicate named columns so you will need to number them if you do have duplicate columns. 

[JakeRysdon]

Thank you, this was helpful.