| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine rows and Qty
Please Help!!!!
My need is to sort, combine similar values of rows in column 1 (having 1 value in cell at the end), then combine refdes in column 2, separated by a comma, (ex C4,C8), then adding quanities (scroll down to see desired end result) PartType RefDes PartDecal QTY CAP_330PF_0805 C3 805 1 CAP_470PF_0805 C4 805 1 CAP_470PF_0805 C8 805 1 CAP_470PF_0805 C9 805 1 CAP_330PF_0805 C11 805 1 PartType RefDes PartDecal QTY CAP_330PF_0805 C3,C11 805 2 CAP_470PF_0805 C4,C8,C9 805 3 Thanks sooo much for your help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to combine rows? | Excel Discussion (Misc queries) | |||
| How do I combine worksheets w/o enough rows to combine? | Excel Worksheet Functions | |||
| Combine rows and add semicolon | Excel Discussion (Misc queries) | |||
| Combine rows | Excel Discussion (Misc queries) | |||
| how to combine the multiple rows into one rows? | Excel Worksheet Functions | |||
Threaded Mode
