Data Preparation

[ayadav8]

Hello,

I am looking to transform my input file so that I can do some analysis on it. The file consists of only 3 columns but these are distributed across spreadsheet columns. I need to group them together in only 3 columns. 

I have attached the spreadsheet example to better explain my case. Hope I am clear. 

Thank you so much.

[CharlieS · Accepted solution]

@ayadav8

If you have input this data into Alteryx, you may have noticed that duplicate column names will have a number appended to the end of each occurrence. Relying on this, I created the attached solution.

[ponraj · Accepted solution]

Here is the solution for your problem...

[ayadav8]

@ponraj & @CharlieS Thank you guys, both the answers were perfect. Thanks again :)