Is it possible to merge columns for HMTL output?

I would like to enter the data in excel's spreadsheet in the typical way, eg.

Age | Gender | Marital Status | Employment | ....

(each |???| represents a column)

But I would like to display this data more compactly so the user does not have to scroll needlessly to the right side of the screen looking at the ugly output.

I would like it to display thusly:

Age
Gender
Marital Status (all in one column, under each other), then the next column would continue to the right

I'd rather not enter it this way so that I can still do searches based on Marital Status, for instance.

Does that make sense? Is it possible?

Use mail merge to Word, then save as html.
************
Anne Troy
www.OfficeArticles.com

"Heartache" <[email protected]> wrote
in message news:[email protected]...
>
> I would like to enter the data in excel's spreadsheet in the typical
> way, eg.
>
> Age | Gender | Marital Status | Employment | ....
>
> (each |???| represents a column)
>
> But I would like to display this data more compactly so the user does
> not have to scroll needlessly to the right side of the screen looking
> at the ugly output.
>
> I would like it to display thusly:
>
> Age
> Gender
> Marital Status (all in one column, under each other), then the next
> column would continue to the right
>
> I'd rather not enter it this way so that I can still do searches based
> on Marital Status, for instance.
>
> Does that make sense? Is it possible?
>
>
> --
> Heartache
> ------------------------------------------------------------------------
> Heartache's Profile:
> http://www.excelforum.com/member.php...o&userid=28277
> View this thread: http://www.excelforum.com/showthread...hreadid=478429
>

Does this help?

Say your datalist was on Sheet1, from A1 to E100.


On Sheet2, enter these formulas in A1 to E1:

=INDEX(Sheet1!$1:$1,ROWS($1:1))
=INDEX(Sheet1!$2:$2,ROWS($1:1))
=INDEX(Sheet1!$3:$3,ROWS($1:1))
=INDEX(Sheet1!$4:$4,ROWS($1:1))
=INDEX(Sheet1!$5:$5,ROWS($1:1))

Then select A1:E1 and drag down to copy to Row100.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

"Heartache" <[email protected]> wrote
in message news:[email protected]...

I would like to enter the data in excel's spreadsheet in the typical
way, eg.

Age | Gender | Marital Status | Employment | ....

(each |???| represents a column)

But I would like to display this data more compactly so the user does
not have to scroll needlessly to the right side of the screen looking
at the ugly output.

I would like it to display thusly:

Age
Gender
Marital Status (all in one column, under each other), then the next
column would continue to the right

I'd rather not enter it this way so that I can still do searches based
on Marital Status, for instance.

Does that make sense? Is it possible?


--
Heartache
------------------------------------------------------------------------
Heartache's Profile:
http://www.excelforum.com/member.php...o&userid=28277
View this thread: http://www.excelforum.com/showthread...hreadid=478429

Thanks!!