I have data in 3 columns. I would like to convert data from Column A to be sub headings and Column B and C to stay as is. Also, if Column A has the same data in Row 1 thru 5, it should be just one heading.
So, For example, raw data is

X 1 2
X 3 4
X 5 6
Y 7 8
Y 9 10

the results should be

X
1 2
3 4
5 6

Y
7 8
9 10

Thanks for any help