Combine multiple text descriptions with the same invoice number

leighnea

New Member
Joined
Jul 25, 2009
Messages
22
Office Version
  1. 365
Platform
  1. Windows
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.
 
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
 
Upvote 0
[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]
 
Upvote 0
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]
 
Upvote 0
leighnea,

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top