Data Preparation

Question

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.

Excel file.xlsx

CharlieS · Accepted Answer

@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 Answer

Here is the solution for your problem...