Combine Duplicates Single Row Excel Words Put 19850 Single Row 13808 Next Row Etc Q13829403

Howdo you combine duplicates into single row in excel?

Eile Edit View Insert Format Tools Data Window Help Feedb Calibri H23 1 Item Numbe. Shipped Ordered Par SumofaTy 2660 CANDLE 2660 FIXTURE ON 2660 GLASS 2 19850 3 19850 4 19850 5 19850 6 13808 7 13808 8 13808 9 13808 50 2660 METAL SCO 2317 MIRROR 2317 ONE 2317 ONE MIRRO 2317 ONE OF SET 2018 BASE 2018 DISC 2018 FINIAL 2018 HARP 2018 SHADE 2018 SOCKET 2018 TURN KNOE 2002 CANDLE 2002 GLASS 2002 METAL SCO 1967 CANOPY 1967 CHAIN 1967 COUNTERR 1967 GLOBE 1967 PLATE 1967 QUICK LINK 5 4 10 26269-1 11 26269-1 12 26269-1 13 26269-1 14 26269-1 15 26269-1 16 26269-1 15 17 19311 18 19311 19 19311 24 20 21811 21 21811 22 21811 23 21811 24 21811 25 21811 26 21811 27 21811 28 21811 29 21811 30 19150 115 1967 RING 1967 SOCKET RIN 1967 sOCKET RIN 1967 TRIM SCREV 1937 BRACKET 1937 CANDLE 1937 CANDLE HO 31 19150 32 19150
In other words put all the 19850 into single row, then all the13808 into the next row, etc.

Eile Edit View Insert Format Tools Data Window Help Feedb Calibri H23 1 Item Numbe. Shipped Ordered Par SumofaTy 2660 CANDLE 2660 FIXTURE ON 2660 GLASS 2 19850 3 19850 4 19850 5 19850 6 13808 7 13808 8 13808 9 13808 50 2660 METAL SCO 2317 MIRROR 2317 ONE 2317 ONE MIRRO 2317 ONE OF SET 2018 BASE 2018 DISC 2018 FINIAL 2018 HARP 2018 SHADE 2018 SOCKET 2018 TURN KNOE 2002 CANDLE 2002 GLASS 2002 METAL SCO 1967 CANOPY 1967 CHAIN 1967 COUNTERR 1967 GLOBE 1967 PLATE 1967 QUICK LINK 5 4 10 26269-1 11 26269-1 12 26269-1 13 26269-1 14 26269-1 15 26269-1 16 26269-1 15 17 19311 18 19311 19 19311 24 20 21811 21 21811 22 21811 23 21811 24 21811 25 21811 26 21811 27 21811 28 21811 29 21811 30 19150 115 1967 RING 1967 SOCKET RIN 1967 sOCKET RIN 1967 TRIM SCREV 1937 BRACKET 1937 CANDLE 1937 CANDLE HO 31 19150 32 19150 Show transcribed image text Eile Edit View Insert Format Tools Data Window Help Feedb Calibri H23 1 Item Numbe. Shipped Ordered Par SumofaTy 2660 CANDLE 2660 FIXTURE ON 2660 GLASS 2 19850 3 19850 4 19850 5 19850 6 13808 7 13808 8 13808 9 13808 50 2660 METAL SCO 2317 MIRROR 2317 ONE 2317 ONE MIRRO 2317 ONE OF SET 2018 BASE 2018 DISC 2018 FINIAL 2018 HARP 2018 SHADE 2018 SOCKET 2018 TURN KNOE 2002 CANDLE 2002 GLASS 2002 METAL SCO 1967 CANOPY 1967 CHAIN 1967 COUNTERR 1967 GLOBE 1967 PLATE 1967 QUICK LINK 5 4 10 26269-1 11 26269-1 12 26269-1 13 26269-1 14 26269-1 15 26269-1 16 26269-1 15 17 19311 18 19311 19 19311 24 20 21811 21 21811 22 21811 23 21811 24 21811 25 21811 26 21811 27 21811 28 21811 29 21811 30 19150 115 1967 RING 1967 SOCKET RIN 1967 sOCKET RIN 1967 TRIM SCREV 1937 BRACKET 1937 CANDLE 1937 CANDLE HO 31 19150 32 19150