Forum Discussion
Solved
How to transform tables
Hi everyone, Thank you so much for this beautiful community, I need your help with something in Excel. How to transform table A to table B? I tried many formulas and looked online for help but co...
- Thank you! I tried Power Query but couldn't get a result similar to yours, can you share the file again but keeping Power Query?
I can share the file again but don't know what "...but keeping Power Query" means.
In the sheet you can add data in the blue table and then click any cell in the green table. Then you can right-click and select refresh to update the result.
- Thank you so much
