Hi, I could really use some help with creating a macro. I have two columns of data. The first column provides me with a list of Part Numbers and the second column Provides the Description of the Part Numbers. There are multiple rows for the Descriptions because that's the way they come into my spreadsheet. Looks something like the following:
(Column A) (Column B) Part Number Description 100-100 Box with Cover and 4 slotted sides 100-211 Bubble Wrap, ESD sensitive 100-344 Shipping crate with pallet. I need the information in column B to be concatenated onto one line, preferably in the same row as the Part Numbers. Any help would be much appreciated. Thanks, Steve --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---