Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Combine Grouped Records onto one row
I have a spreadsheet that looks like this: TYPE BIN KEY BOOK ABC A513 BOOK ABC B134 BOOK DEF W222 BOOK DEF A678 BOOK DEF N890 BOOK DEF N333 BOOK XYZ D444 BOOK XYZ E555 BOOK XYZ F777 I want to be able to combine the records with same TYPE/BIN onto one row putting the different keys into the same cell, like this: TYPE BIN KEY BOOK ABC A513, B134 BOOK DEF W222, A678, N890, N333 BOOK XYZ D444, E555, F777 Is there a way to do this? Thanks, Lynn -- Message posted via http://www.officekb.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine duplicate records in one row - In desperate need!!! | Excel Discussion (Misc queries) | |||
How can I combine multiple csv files with different number of records? | Excel Discussion (Misc queries) | |||
Combine several records into one | Excel Discussion (Misc queries) | |||
Combine records from 2 tables whenever there are matching values . | Excel Programming | |||
combine two records | Excel Programming |