I have a column of data like column B below. The letter "A" denotes software, "B" a service and "C" hardware. How do I match each product with its category to make it look like the table below?
A B -------------- Software A1 Software A2 Software A3 Software A4 Service B1 Service B2 Service B3 Service B4 Hardware C1 Hardware C2 Hardware C3 Hardware C4
How would I achieve this in Excel?