Forum Discussion
haitham
Sep 08, 2022Copper Contributor
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...
- Sep 08, 2022
Patrick2788
Sep 08, 2022Silver Contributor
dscheikey
Sep 08, 2022Bronze Contributor
And with formulas instead of pivot: You need UNIQUE(), FILTER().