Combine multiple columns?

[kceesay]

Hi Everyone,

I'm hoping I can combine multiple columns or rows that have the same data in the first record. I tried to use dynamic renaming to make the first record my header then summarize but it wouldn't allow duplicate naming. I just want one column of all machines one of all Grade type and one of all scale. Thank you for any advice!

[binu_acs]

@kceesay Alteryx will not allow the same name for multiple columns, the column names should be unique. What is the expected output here?

[kceesay]

Hi,

I just want one column of all machines, one of all Grade type and one of all scales.

[binu_acs]

@kceesay would you be able to upload the input data in excel?

[kceesay]

Yes, I've attached the file. What I currently have is in sheet 1 and I'm looking to have what's in sheet 2.

[Christina_H · Accepted solution]

Try this

[kceesay]

This worked Thank you!!