Need help with organizing mixed data in same Excel sheet

[KJ-Cerum]

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 1	Column 2	Column 3	Column 4
Data 1	Data 2	Data 3	Data 4
Data 1	Data 2	Data 3	Data 4
- blank excel line
Column 1	Column 3	Column 4
Data 1	Data 3	Data 4

[binuacs]

@KJ-Cerum One way of doing this with the Union tool - Auto Config by position option

[JosephSerpis]

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.

[Felipe_Ribeir0]

Hi @KJ-Cerum 

One way of doing this

[KJ-Cerum]

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 :)