Help transforming data with bizarre design-pattern

[danrope]

Recently I was asked to add a [task list estimates] table to our data warehouse. The structure of this data has me confused as to how to proceed.

As you can see, the month name appears accross twelve columns - and this entire thing is just breaking my brain. Anybody have experience or advice for how to transform this data into something more suitable for dimensional model?

[danrope]

Thank you @johnt75 . For some reason the terminology "pivot / unpivot" totally escaped me!

[johnt75 · Accepted solution]

First change the column names to add "-25" to them, e.g. "Jan-25".

Then select the first three columns, go to the Transform tab and choose Unpivot Other Columns. You can then turn the attribute column into a date type, and obviously rename the columns appropriately