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
Watch video 79 - Handling a weird data structure (blanks and transpose) (Power Query) online without registration, duration hours minute second in high quality. This video was added by user WesleySon 25 February 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 63 once and liked it 3 people.