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]