Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Columns | Excel Discussion (Misc queries) | |||
Macros for find and replace and then joining columns | Excel Discussion (Misc queries) | |||
How do I do an excel merge like a word mailmerge with another exc. | Excel Discussion (Misc queries) | |||
how do you merge two columns in excel | Excel Discussion (Misc queries) | |||
How do I merge the contents of two columns? | Excel Discussion (Misc queries) |