| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Columna to Rows Formula
I have entered transactions in columns in Sheet1 and need to set up formulas
in Sheet2 to bring that data into Rows in order to set up a table for filtering and sorting. Example: Sheet1 the transactions are entered as folllows: C5:C59, D5:D59, E5:E59 and so on... I want those transactions to go into Sheet2, beggining at A6, in rows as follows: A6:BC6 would be Sheet1 C5:C59 A7:BC7 would be Sheet1 D5:D59 A8:BC8 would be Sheet1 E5:E59 and so on... Special formulas??? Your help is appreciated!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF value columnA columnB | Excel Worksheet Functions | |||
| sum up columnA depending on conditions on columnB and columnC | Excel Discussion (Misc queries) | |||
| Cambiar color fila dependiendo de valor de columna | Excel Discussion (Misc queries) | |||
| IF ColumnA = ltr Add Column B | Excel Worksheet Functions | |||
| Adding new numbers as I type without duplicates from Sheet1,ColumnA to Sheet2,ColumnA | Excel Worksheet Functions | |||
Threaded Mode
