79 - Handling a weird data structure (blanks and transpose) (Power Query)
I had a weird datastructure where I don't simply have a row with a date, rather one row with the month name and a row with the day of the month.
I need to combine information from two rows to create the correct column headers.
I also need to deal with blanks/null values being valid, and replacing values in ALL columns + future proofing my formula.
00:00 Data structure
00:58 Create the column headers
03:01 Calculated column to create the date
03:57 Second transpose
05:07 Append queries
06:09 Unpivot
07:03 Replace values, on all columns