You can accomplish with a pivot table. Set up the pivot table with your data
and put the company, person, city, telephone fields in rows and set the field
settings for each to outline. Also set the company field settings to include
a blank line after each one. Then in a cell outside of the pivot table enter
a formula to concatenate the four cells containing the data on each line such
as =B5&C5&D5&E5 where one field will have info and the three others will be
blank. The result will be the information (company, person, city, telephone)
in each row. You can then copy and paste/special and select values. Then
you can delete the pivot table.
Gary

"Lois Lane" wrote:

> 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!