Is it possible to merge columns for HMTL output?

H

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?
 
R

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?
 
Top