| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multi rows to single row
I have a spreadsheet with multiple rows and want to take info from it to a
new sheet in single rows. Eg. Company Name Sale A $100 Sale B $200 Sale C $300 Total $600 to a new sheet that shows Comany Name Total What type of formula do I need? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multi rows to single row
Assuming the sets are all five rows in Column A of Sheet1 enter this in A1 of
Sheet2 =INDEX(Sheet1!$A:$A,(ROWS($1:1)-1)*5+COLUMNS($A:B)-1) Copy across to E1. Select A1:E1 and copy down until you get 0's showing up. Gord Dibben MS Excel MVP On Thu, 25 Jan 2007 13:50:00 -0800, jostlund wrote: I have a spreadsheet with multiple rows and want to take info from it to a new sheet in single rows. Eg. Company Name Sale A $100 Sale B $200 Sale C $300 Total $600 to a new sheet that shows Comany Name Total What type of formula do I need? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF in between rows | Excel Worksheet Functions | |||
| Converting a number of rows into a single column | Excel Discussion (Misc queries) | |||
| formula to use when number of rows changes dynamically | Excel Worksheet Functions | |||
| Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
| Multiple rows of data on a single axis (charting) | Charts and Charting in Excel | |||
Linear Mode
