Site icon The Learning Zone

Dynamic Power Query Cross Tab Reports – Pivot n Rows to n Columns 2 Ways!

Dynamic Power Query Cross Tab Reports – Pivot n Rows to n Columns 2 Ways!
YouTube video player

Microsoft Excel Tips and Tricks

Pivoting a variable number of rows into a variable number of columns into a cross tab style report requires some tinkering under the hood.

Credit MyOnlineTrainingHub

Exit mobile version