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 couldn't figure it a way to achieve it in excel.
I need the result to be as shown in in the screenshot.
Thanks in advance for your help.
8 Replies
- 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 Patrick2788 for the quick reply, works fine for the first rows then started showing duplicate values when applied to large tables, I'm not sure what went wrong!
And with formulas instead of pivot: You need UNIQUE(), FILTER().
