Convert report to database with Excel PowerQuery's Unpivot

00:00 Go from pivot data to unpivot data in Excel
00:10 Data with months in different columns, data in rows
00:17 Need all months data in single column
00:43 Import the report style into PowerQuery via Data ribbon
01:04 Make first row the headers
01:25 Remove blank rows
01:40 Make all months appear in single column with data next to it
01:54 Unpivot the month columns in PowerQuery
02:10 All turnover data shown in single column with matching month column (data is normalized)

Power Queries best tool. Easily unpivot data i.e. where a report appears with months across columns and data in the rows, but you need it to be all in the minimum number of columns where the amounts are all in a single column and another column specifies what month the amount belongs to, then the unpivot function is for you.