You have a client/BA that likes storing data like this:
Cursing them out still hasn’t gotten it into a form that you can use to stick into Oracle, so try Unpivoting.
This post written based on instructions found here.
Download Excel Power Query Add-on here.
(Optional) Convert to a table to make it easier to work with. Highlight all relevant data and click “Format as Table”
From “POWER QUERY” tab, click “From Table/Range”.
We will remove the 1st column because it is identical information as column 2. Unpivot works best with one “header” column and one “header” row.
Then select your “header” column, right-click, and select “Unpivot Other Columns”.
Click “Close & Load”
Rejoice as a new worksheet is added to the end of your workbook with the Unpivoted data.
The audio is messed up. I think it might be a feature in Windows 10 noise cancellation (microphone picking up audio from speakers?) as it worked fine before in Win 7.
Luc may be reached at luckner.thermonvil@tc.gc.ca