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 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().
