reformat columns to rows?

Hi there, people.
Got two columns: Column "A" has (for instance) cars. (Buick, Chevy and
Ford). Column B has parking lot numbers: (1,2,3,4) all in separate cells.
Now, without a lot of typing, how would I change it thus: Take all Buicks,
place them in only one row. Now following the same row, separate cells,
place the parking spaces. Now I no longer have 14 rows of BUICK due to 14
parking spaces, I now have one row for BUICK and 14 parking spaces (across),
same row.

Rick
TimberWolfe21@(thisisme.)cox.net

A Pivot Table will do this nicely...........

Vaya con Dios,
Chuck, CABGx3



"RickyDee" wrote:

> Hi there, people.
> Got two columns: Column "A" has (for instance) cars. (Buick, Chevy and
> Ford). Column B has parking lot numbers: (1,2,3,4) all in separate cells.
> Now, without a lot of typing, how would I change it thus: Take all Buicks,
> place them in only one row. Now following the same row, separate cells,
> place the parking spaces. Now I no longer have 14 rows of BUICK due to 14
> parking spaces, I now have one row for BUICK and 14 parking spaces (across),
> same row.
>
> Rick
> TimberWolfe21@(thisisme.)cox.net