LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Have data with multiple records associated to same ID

My Data Situation:

A B
33007014220000 33007014220000 DLL
33007014220000 CND
33007014220000 CBL

Need to get it like this:
A B
33007014220000 CBL,CND,DLL


Is there a way to do this via formulas or code? I am doing it by hand and
will take days to go through 1683 Unique records.

Thanks for your help!
Dan


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Delete records when certain records have duplicate column data JVroom New Users to Excel 1 January 26th 09 06:23 PM
Creating a Custom Data Entry Form to Update Multiple Excel Records atOnce Scotty81 Excel Discussion (Misc queries) 0 January 7th 09 08:22 PM
Combining multiple data records Compass Rose Excel Discussion (Misc queries) 13 July 2nd 08 10:36 PM
Combining multiple data records Compass Rose Excel Worksheet Functions 3 July 1st 08 10:29 PM
return multiple records matching multiple criteria Karthik Excel Worksheet Functions 2 March 22nd 06 04:42 PM


All times are GMT +1. The time now is 04:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"