Thank you, Gary - I'll try it!

"Gary Rowe" wrote:

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