I have two columns of data I'm importing into Excel from SQL.
Column A (Product) has values that will appear 1 to x number of times based on matching results from Column B (Components).
What I'm trying to accomplish is to get the components for each product into a horizontal list:
P1 C1 C5 C8 C9
P2 C2 C3
P3 C1 C2 C3
I'm dealing with about 50,000 rows of data.
I'm not sure how to transpose this data. Any suggestions?