Is it possible to merge columns for HMTL output?

[Heartache]

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?

 

[Anne Troy]

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

 

[RagDyeR]

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

in message
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]

Thanks!! :