This was by far the easiest solution! Thank you very much, Jason!
Initially, it wouldn't work, but I realized your formula was on two lines
instead of one - once I pasted it all on one line, it was perfect!

Thanks again.

"Jason Morin" wrote:

> Another way would be to select the 5th col. on your data
> sheet (assuming it's named "mysht"), enter ="", and press
> <ctrl><enter>. Now on a new sheet in A1 put:
>
> =OFFSET(mysht!$A$1,ROUNDUP(ROW()/5,0)-1,ROW()-(ROUNDUP(ROW
> ()/5,0)*5-5)-1)
>
> and copy down as far as needed.
>
> HTH
> Jason
> Atlanta, GA
>
> >-----Original Message-----
> >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!
> >.
> >
>