I have some data in one column that is dynamic, and being added to automatically:
Brand 1
Brand 2
Brand 3
Brand 4
Brand 5
Brand 2
Brand 2
Is it possible to transpose these, without duplicates to be headers in a row, ideally by just adding a formula in the Brand 1 cell?
E.g. Brand 1, Brand 2, Brand 3, Brand 4, Brand 5