Dynamic Power Query Cross Tab Reports – Pivot n Rows to n Columns 2 Ways! neha sharma 3 years ago 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