Convert matrix to list with Excel PowerQuery (property occupancy list)

00:00 Convert an occupancy matrix (year and month) into a list
00:10 Load the matrix into Power Query
00:15 Remove unnecessary columns
00:30 Transpose or unpivot of the matrix
00:40 Try a transpose- does it look right?
00:49 Remove the transpose step from the Power Query applied steps
00:59 Try an unpivot to untangle the matrix of data- does it look correct
01:20 Unpivot not correct? Needs key data in the header row (not column1, 2 etc)
01:36 Unpivot of matrix with months in headers works correctly
01:50 Rename the columns Attribute and Value after an Unpivot

The process to get a matrix of data (years in columns, months in rows) into a list, where the year, month and the value (occupancy percentage in this case) appear in their own rows which makes it easier to do a lookup on the data in the rest of the spreadsheet. The main issue is to see whether it is a Transpose or Unpivot in Excel's PowerQuery and what to be careful with when your Unpivot does not look like it is working, but it is very close.