| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consolidate data from multiple rows
Hi All,
I have a data which has same item spread over 5 or 6 rows and looks like this Item # T1 T2 T3 T4 T5 1005 Emp 1 1005 Emp2 1005 Emp3 1005 Emp1 108 Epm3 1005 Epm2 I'm trying to consolidate each Item # into a single Row but couldn't get a formula to do this. I want this data to look like Item # T1 T2 T3 T4 T5 1005 Emp 1 Emp2 Emp3 Emp1 Emp2 108 Epm3 Please help me to consolidate this table. Thanks for your help in advance. -- Karthi |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match consolidate multiple rows data into one row | Excel Worksheet Functions | |||
| Consolidate data from worksheet (more then 65536 rows) | Excel Discussion (Misc queries) | |||
| Consolidate data from multiple worksheets into one | Excel Discussion (Misc queries) | |||
| How to open/consolidate details for multiple rows in a PivotTable | Excel Discussion (Misc queries) | |||
| How to consolidate data from multiple worksheets. | Excel Worksheet Functions | |||
Threaded Mode
