Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to swap rows and columns? | Excel Discussion (Misc queries) | |||
Changing Columns to Rows | Excel Discussion (Misc queries) | |||
hidden rows & columns slow file open | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Can I split my worksheet and have different size columns and rows. | Excel Discussion (Misc queries) |