Changing Columns in Excel Document

[IanCo]

Hello,

I have an excel document that gets new data put into it every week. However, sometimes the column order changes as shown in the attachment. 

How can I prep my data to make one nice table that all the column are aligned correctly? There isn't only one line of data with every entry like the attachment.

@Kiran_Bhore

Thanks!

[Inactive User · Accepted solution]

Answer attached.

[IanCo]

Thank you @Inactive User! It looks like this solution scales to more than one row of info in the sectioned tables. Correct?