Forum Discussion
How to transform wide-format data into the structure shown in 'Result' sheet using Power Query?
Hi everyone, I have a dataset in wide format in the "Data" sheet, and I’d like to reshape it using Power Query to match the format shown in the "Result" sheet. What the source looks like (Data shee...
In the attached file you can add data to the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.