Combine multiple text descriptions with the same invoice number

[leighnea]

We have a very long list exported from our system that has multiple lines of descriptions with the same invoice number. We need to merge this so we can merge it with another file.

 

[hiker95]

leighnea,

We would like more information. Please see the Forum Use Guidelines in the following link:

http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html


See reply #2 at the next link, if you want to show small screenshots, of the raw data, and, what the results should look like.

http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729


Or, you can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com

 

[Amanda Wilso]

[FONT=q_serif]The simplest CONCATENATE formula to combine the values of cells A1 and B1 is as follows:
=CONCATENATE(A1, A2 )
or
“&” operator
=A1 & A2 & A3



[/FONT][FONT=q_serif][/FONT]

 

[leighnea]

column A is the invoice #
column B is the description of each item
column C I need the concatenate of each invoice number.


I used the concatenate / transpose formula and it works but I need it to do the entire worksheet without me having to manually do it.

[TABLE="width: 815"]
<tbody>[TR]
[TD]Supplier inv #[/TD]
[TD]Item desc[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]653811[/TD]
[TD]king fitted sheet 78x80x12 brown hem thread[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3323194787[/TD]
[TD]Sanford Expo Dry-Erase Marker Set and Eraser Organizer[/TD]
[TD]Sanford Expo Dry-Erase Marker Set and Eraser Organizer, Deflecto Unbreakable Docupocket Wall File Set, Letter, 3 Pockets, Clear, 6 1/2"H x 14 1/2"W x 3"D, 3/Pk, Pilot G2 Premium Retractable Gel Ink Rolling Ball Pens, Fine Point, 0.7 mm, Black Ink / Clear Barrel, 12/Pk, Quartet Premium Felt Chalk Eraser, Heavy Use, 5" x 2" x 1.25", Binney & Smith Crayola Anti-Dust Chalk, White, 12/Bx, [/TD]
[/TR]
[TR]
[TD="align: right"]3323194787[/TD]
[TD]Deflecto Unbreakable Docupocket Wall File Set, Letter, 3 Pockets, Clear, 6 1/2"H x 14 1/2"W x 3"D, 3/Pk[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3323194787[/TD]
[TD]Pilot G2 Premium Retractable Gel Ink Rolling Ball Pens, Fine Point, 0.7 mm, Black Ink / Clear Barrel, 12/Pk[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3323194787[/TD]
[TD]Quartet Premium Felt Chalk Eraser, Heavy Use, 5" x 2" x 1.25"[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3323194787[/TD]
[TD]Binney & Smith Crayola Anti-Dust Chalk, White, 12/Bx[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3706332132[/TD]
[TD]Coffee and condiment kits[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]45076[/TD]
[TD]beer inventory[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]203155[/TD]
[TD]beer inventory[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]368730[/TD]
[TD]MAINTENANCE FOOT PEDAL[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1001378611[/TD]
[TD]PSAV[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4427185[/TD]
[TD]liquor inventory[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4427175[/TD]
[TD]liquor inventory[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4430405[/TD]
[TD]liquor inventory[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4427202[/TD]
[TD]liquor inventory[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3323594986[/TD]
[TD]Staples OOPS! Sidewinder Correction Tape, White, 1/5" x 394", 6/Pk[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3323594986[/TD]
[TD]Staples Inkjet Business Cards, Matte, White, 2" x 3 1/2", 1,000/Pk[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3323594986[/TD]
[TD]Westcott All Purpose Scissors, Pointed Tip, 8", Value with Bent Handle, Red, Black, and Blue, 3/Pack[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3323594986[/TD]
[TD]Staples Paper Clips, Jumbo, Smooth, 1000/Pk[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3323594986[/TD]
[TD]Clorox Disinfecting Wipes Value Pack, Scented, 105 Count total, 3 Canisters[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3323594986[/TD]
[TD]HP 410A Black Original LaserJet Toner Cartridge[/TD]
[TD][/TD]
[/TR]
</tbody><colgroup><col><col><col></colgroup>[/TABLE]

 

[hiker95]

leighnea,

Are all the identical/same Supplier inv #'s, in Column A, grouped together like in your flat text display?