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?


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

Is it possible to merge columns for HMTL output?
 

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

"Heartache" wrote
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
------------------------------------------------------------------------
Heartache's Profile:
http://www.excelforum.com/member.php...o&userid=28277
View this thread: http://www.excelforum.com/showthread...hreadid=478429

Is it possible to merge columns for HMTL output?
 

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" wrote
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
------------------------------------------------------------------------
Heartache's Profile:
http://www.excelforum.com/member.php...o&userid=28277
View this thread: http://www.excelforum.com/showthread...hreadid=478429

Is it possible to merge columns for HMTL output?
 

Thanks!! :)


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