I have a 2-column table with rows as such:
1 Brand1
1 Brand2
2 Brand3
2 Brand4
2 Brand2
2 Brand5
3 Brand5
3 Brand2
4 Brand3
I would like to turn each value from the 1st column into a column header and below have the list of values from the 2nd column:
1 2 3 4
Brand1 Brand3 ... ...
Brand2 Brand4 ...
Brand2
Brand5
I can't do it through a pivot table, as it must have a numeric value to compute (sum, count, ...) and I haven't found any help, as actually it is quite difficult to explain and to look after a solution in Google (choosing the right terms).
I know there are solutions (in VBA) to do the opposite, but did not manage to find a solution to my problem.
I have seen some specific terms such as "fold" or "unfold" but I'm not sure which one is right nor if it is appropriate here.