Forum Discussion
Power Query Data Stacking/Unstacking Inquiry
You can try this Power Query suggestion. In the attached file you can add data to the large 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.
The data layout in the screenshot and in the attached file is for illustration. You can place the green result table to the right of the blue table or in another worksheet.
You can try this Power Query suggestion. In the attached file you can add data to the large 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.
The data layout in the screenshot and in the attached file is for illustration. You can place the green result table to the right of the blue table or in another worksheet.
OliverScheurich Thank you, this looks great.
Would it be possible by chance to list/provide a screenshot of your applied steps for transformation? I unfortunately am not able to open the file at this time.Disregard - I was able to open the file. Another question, would the steps work if i were to enter partial records? i.e. missing a DOB, or email?
You are welcome. The solution doesn't work for partial records. It requires all the information which is expected in the output table (name, ssn, dob and email).
