| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Col to Rows Formula?
Excel2003 ...
WorkSheet 1 ... Col Range A2:A10 (my range larger, but this will do) contains "Text" (numbers which may have leading 0's fomatted as Text) WorkSheet 2 ... Row Range A2:I2 I wish Formula in WS2 Row Range to = WS1 Col Range? I can do this, but not looking to do it 1 cell @ a time ... Is there an easier way? ie: WS2 Cell A2 = WS1 Cell A2 WS2 Cell B2 = WS1 Cell A3 WS2 Cell C2 = WS1 Cell A4 etc. Thanks ... Kha |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to insert rows by formula. | Excel Discussion (Misc queries) | |||
| Formula to sum rows | Excel Discussion (Misc queries) | |||
| Formula for Duplicating Rows!! | Excel Discussion (Misc queries) | |||
| I get error with "ROWS" in the formula - nested formula question | Excel Worksheet Functions | |||
| can you hide rows with a formula? | Charts and Charting in Excel | |||
Threaded Mode
