Need Help Converting Tabular Data to Columns

Thanks to all for their help on this forum. Great job !!

I was wondering if someone coule help me. I would wonder is there an easy way to reorganize tabular data into individual columns ie. a macro ...


ORIGINAL DATA
--------------
Columns (C to AF): Car Models
Rows (3 to 62): Car Colors

B C D E F ..... AF
2 Audi Merceds Honda Toyota Chevrolet
3 Red 10 11 12 41 23
4 Pink 2 2 0 5 3
.
.
.
6 Green 0 34 5 21 11



NEW DATA
--------
C D E F ..... AF AG AH AI AJ .......
Red Audi Red Mercedes Red Honda Red Toyota Red Chevrolet Pink Audi Pink Merceds Pink Honda Pink Toyota
10 11 12 41 23 2 2 0 5 .......

I've attached a txt file if the formatting of this message gets messed up.

Thanks.
-raj