| 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? |
| 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 | |||
Threaded Mode
