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
>
If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook, and
Tools|Options|View|Zero values is unchecked

=TRANSPOSE(MakeArray(A1:E2,1)) array entered

Alan Beban