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.

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

<tbody>
</tbody><colgroup><col><col><col></colgroup>

 

[hiker95]

leighnea,

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