Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Excel's help file provides a specific formula to convert multiple rows to
columns. However, I need help in converting multiple columns to rows, placing a blank row inbetween each set of records. Right now, the data is in this format, representing 4 columns: ABC Company John Doe Anytown (000)000-0000 XYZ Company Jane Smith Metropolis (000)555-5555 I need the data to be formatted as such: ABC Company John Doe Anytown (000)000-0000 XYZ Company Jane Smith Metropolis (000)555-5555 I tried modifying the formula provided by Microsoft to convert rows to columns, but it didn't work. Thanks, in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I convert columns to rows? | Excel Discussion (Misc queries) | |||
how do I easily convert a single column of text (multiple rows si. | Excel Discussion (Misc queries) | |||
interchange columns with rows | Excel Discussion (Misc queries) | |||
how to convert multiple columns of data into one single column? | Excel Worksheet Functions | |||
Count rows based on multiple criteria | Excel Worksheet Functions |