reformat columns to rows?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reformatting data 3
DE-Concatenate but maintain relationship and record structure 1
De-concatenate but maintain relationship/record structure 3
text to column 1
Extracting data from Multiple columns to a Single row 1
Column Rearrange same row 5
using row number or column letters in formula 5
Rearrange data into Columns in same row 6

Back
Top