Transpose only selected rows into columns (for over 190 columns)
I have a table with the following data. The dataset has over 190 columns. Each column has top 7 rows that are actually query parameters set while extracting this data from another system (Entity, Activity, Year, Month, Scenario, Version, Product) and the first 2 columns of my data set are used for DeptID and Account Number. I'd like to format this table in Power Query Editor, and make each of the top 7 rows their own columns. See the 2nd screenshot for intended result.
Problem DatasetIntended Result
I have been making unsuccessful attempts and tried many combinations of transpose, pivot/unpivot. Any help would be appreciated!
@mcybulski You're awesome!! I was missing the merged part in the beginning and therefore struggling to reach the solution. Thank you so much for your quick response! This has resolved the issue! Much Appreciated!! 🙂