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
>