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.
Solved! Go to Solution.
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.