|
|
Thank you, Alan!
"Alan Beban" wrote:
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
|