Help with converting wonky excel columns to proper column names

[csh8428]

I have a spreadsheet(sample attached) where the column headers are proving difficult for me to ETL to a standard tabular format I was hoping I could get some help with.

The first 2 rows contain what I want to be 1 header row. The 2nd row  from the spreadsheet should be the first part of the new header row and the 2nd row from the spreadsheet should be added to the "new" 1st header row as a suffix.(see screenshot).  This is also shown in the "Get to This" sheet in the attached sample spreadsheet

Thanks,

Craig 

[IraWatt · Accepted solution]

Hey @csh8428,

Here is one way of doing this:

Not the easiest file to work with ever.

Any questions or issues please ask :)
HTH!
Ira

[csh8428]

@IraWatt Thanks!

That was a totally different approach than the various ways I was trying to figure it out.

Kind Regards,

Craig

[IraWatt]

No worries @csh8428 ! I'm sure it can be improved a fair bit, feels like it should be an easier task 😄