Need help with organizing mixed data in same Excel sheet

Question

Hi all,

I would like to organize my Excel sheet which contains the output of multiple XML files with the same column names, but in mixed columns. An example of the data is given below.

As you can see there is structure as the column names do match up. Is there a way to organize an excel file like below?

Thanks in advance and happy holidays to everyone!

Column 1Column 2Column 3Column 4Data 1Data 2Data 3Data 4Data 1Data 2Data 3Data 4- blank excel line   Column 1Column 3Column 4 Data 1Data 3Data 4

KJ-Cerum · Answer

Thank you all for your responses! My datafile is however made up from 236 SEPA-XML files some having 45 columns in one Excel sheet. This does not provide me with the opportunity to split the 236 files to different inputs and then match it. Same goes for the columns as it does not include values but has 45+ descriptions.

The perfect solution would be if Alteryx searches the right columns and adds the data right beneath it. And this for all the 236 sections and then matches the columns including the data in order to make one workable file. Sounds even more difficult now that I'm writing it down :)

Felipe_Ribeir0 · Answer

Hi @KJ-Cerum

One way of doing this

Arrange the dataset based on column name.yxzp

JosephSerpis · Answer

Hi @KJ-Cerum you will need to use a transpose tool for your excel sheet and then crosstab to organise your data into the correct columns.