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