Using Excel (office 365) on mac, I want to group data by a specific column value, as in a pivot table, but without aggregating it. As an example, i would like to transform:
A 2
B 1
A 3
B 4
to:
A B
2 1
3 4
I've tried using pivot tables, but those seem to require some form of aggregation, which I don't want. I only want to list these values.
UNIQUE
TRANSPOSE
FILTER
and/orXLOOKUP
. If you are still stuck after using these, then come back and edit your question with where you are stuck. Good luck.