| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need to consolidate a list into rows
I have a chartwith part numbers in column A and operation numbers in column B
looks like this 025121 | 010 025121 | 020 025121 | 050 025121 | 090 129017 | 010 129017 | 050 I want it to look like this 025121 | 010 | 020 | 050 | 090 129017 | 010 | 050| and so on, problem is there are over 7000 part numbers each with 5 to 50 operation numbers, I cant possibly do this by hand.... can a function tackle this for me? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Matching items in 2 list to consolidate to one list | Excel Discussion (Misc queries) | |||
| Consolidate rows & amounts with the same heading | Excel Discussion (Misc queries) | |||
| How to consolidate/sum a list | Excel Discussion (Misc queries) | |||
| How to consolidate/sum a list | Excel Worksheet Functions | |||
| Consolidate list from multiple worksheets | Excel Worksheet Functions | |||
Threaded Mode
