Data from Column to row

I

imraja12

New Member
Joined
Aug 29, 2017
Messages
5
I have data exported from a POS that is listed downways with common Invoice number. What i need is to have it listed on a single row for each invoice.

Current data

[TABLE="width: 2420"]
<tbody>[TR]
[TD]District[/TD]
[TD]Invoiced At[/TD]
[TD]Sold On[/TD]
[TD]Invoice #[/TD]
[TD]Sold By[/TD]
[TD]Customer[/TD]
[TD]Product SKU[/TD]
[TD]Product Name[/TD]
[TD]Tracking #[/TD]
[TD]Refund[/TD]
[TD]Qty[/TD]
[TD]Gross Profit[/TD]
[TD]Category[/TD]
[TD]Contract #[/TD]
[/TR]
[TR]
[TD]City[/TD]
[TD]New York[/TD]
[TD="align: right"]8/1/2017[/TD]
[TD]W1036IN15547[/TD]
[TD]John Smith[/TD]
[TD]Customer Name (differnet per invoice)[/TD]
[TD]CAOTVZ000203[/TD]
[TD]4G LTE 3FF NFC SIM CARD[/TD]
[TD][/TD]
[TD]No[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]15.72[/TD]
[TD] >> Accessory >> Other >> SIM Cards[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]City[/TD]
[TD]New York[/TD]
[TD="align: right"]8/1/2017[/TD]
[TD]W1036IN15548[/TD]
[TD]John Doe[/TD]
[TD]Customer Name (differnet per invoice)[/TD]
[TD]AYSPAF000429[/TD]
[TD]FIXURCRACK IPHONE 7 TEMPERED GLASS[/TD]
[TD][/TD]
[TD]No[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]8[/TD]
[TD] >> Accessory >> Screen Protection >> Tempered Glass >> Generic Tempered Glass >> Smartphone Generic TG[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]City[/TD]
[TD]New York[/TD]
[TD="align: right"]8/1/2017[/TD]
[TD]W1036IN15549[/TD]
[TD]John Smith[/TD]
[TD]Customer Name (differnet per invoice)[/TD]
[TD]FESFNS000035[/TD]
[TD]READY?GO! PACKAGE[/TD]
[TD="align: right"]3253674519[/TD]
[TD]No[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]24.95[/TD]
[TD] >> Fees >> Service Fees[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]City[/TD]
[TD]New York[/TD]
[TD="align: right"]8/1/2017[/TD]
[TD]W1036IN15550[/TD]
[TD]Charles Smith[/TD]
[TD]Customer Name (differnet per invoice)[/TD]
[TD]CAOTVZ000203[/TD]
[TD]4G LTE 3FF NFC SIM CARD[/TD]
[TD][/TD]
[TD]No[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]15.72[/TD]
[TD] >> Accessory >> Other >> SIM Cards[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]City[/TD]
[TD]New York[/TD]
[TD="align: right"]8/1/2017[/TD]
[TD]W1036IN15551[/TD]
[TD]Joe Who[/TD]
[TD]Customer Name (differnet per invoice)[/TD]
[TD]AYPRAF000262[/TD]
[TD]FIX UR CRACK 2.1A CARPORT[/TD]
[TD][/TD]
[TD]No[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]32.09[/TD]
[TD] >> Accessory >> Power >> Carport >> Generic Carports[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]City[/TD]
[TD]New York[/TD]
[TD="align: right"]8/1/2017[/TD]
[TD]W1036IN15552[/TD]
[TD]John Smith[/TD]
[TD]Customer Name (differnet per invoice)[/TD]
[TD]CLVZAP002496[/TD]
[TD]APPLE IPHONE 7 128GB - ROSE GOLD (MNAM2LLA)[/TD]
[TD="align: right"]355830087480936[/TD]
[TD]No[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD] >> Activations >> Verizon Wireless >> Equipment >> Apple iPhones >> Apple iPhone - New[/TD]
[TD="align: right"]168533884[/TD]
[/TR]
[TR]
[TD]City[/TD]
[TD]New York[/TD]
[TD="align: right"]8/1/2017[/TD]
[TD]W1036IN15552[/TD]
[TD]John Smith[/TD]
[TD]Customer Name (differnet per invoice)[/TD]
[TD]CLVZRB002329[/TD]
[TD]DPP Phone Rebate[/TD]
[TD="align: right"]2193849338[/TD]
[TD]No[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD] >> Activations >> Verizon Wireless >> Phone Rebates (VZ Commission) >> Device Payment (Reimbursement)[/TD]
[TD="align: right"]168533884[/TD]
[/TR]
[TR]
[TD]City[/TD]
[TD]New York[/TD]
[TD="align: right"]8/1/2017[/TD]
[TD]W1036IN15552[/TD]
[TD]John Smith[/TD]
[TD]Customer Name (differnet per invoice)[/TD]
[TD]CLVZNS000410[/TD]
[TD]iPhone Rate Plan (Device Payment)[/TD]
[TD][/TD]
[TD]No[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD] >> Activations >> Verizon Wireless >> Rate Plans[/TD]
[TD="align: right"]168533884[/TD]
[/TR]
[TR]
[TD]City[/TD]
[TD]New York[/TD]
[TD="align: right"]8/1/2017[/TD]
[TD]W1036IN15552[/TD]
[TD]John Smith[/TD]
[TD]Customer Name (differnet per invoice)[/TD]
[TD]CLVZRB002321[/TD]
[TD]Device Payment Upgrade iPhone (Rate Plan Rebate)[/TD]
[TD="align: right"]2193849338[/TD]
[TD]No[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]150[/TD]
[TD] >> Activations >> Verizon Wireless >> Rate Plan Rebates[/TD]
[TD="align: right"]168533884[/TD]
[/TR]
[TR]
[TD]City[/TD]
[TD]New York[/TD]
[TD="align: right"]8/1/2017[/TD]
[TD]W1036IN15552[/TD]
[TD]John Smith[/TD]
[TD]Customer Name (differnet per invoice)[/TD]
[TD]CLVZRB002691[/TD]
[TD]ASURION - DPP NEW SPF[/TD]
[TD="align: right"]2193849338[/TD]
[TD]No[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]70[/TD]
[TD] >> Activations >> Verizon Wireless >> Features >> Features - SPF[/TD]
[TD="align: right"]168533884[/TD]
[/TR]
[TR]
[TD]City[/TD]
[TD]New York[/TD]
[TD="align: right"]8/1/2017[/TD]
[TD]W1036IN15552[/TD]
[TD]John Smith[/TD]
[TD]Customer Name (differnet per invoice)[/TD]
[TD]CLVZRB002697[/TD]
[TD]ASURION - DPP Dropped\Renewal[/TD]
[TD="align: right"]2193849338[/TD]
[TD]Yes[/TD]
[TD="align: right"]-1[/TD]
[TD="align: right"]-30[/TD]
[TD] >> Activations >> Verizon Wireless >> Features >> Features - No SPF[/TD]
[TD="align: right"]168533884[/TD]
[/TR]
[TR]
[TD]City[/TD]
[TD]New York[/TD]
[TD="align: right"]8/1/2017[/TD]
[TD]W1036IN15552[/TD]
[TD]John Smith[/TD]
[TD]Customer Name (differnet per invoice)[/TD]
[TD]CLVZRB002761[/TD]
[TD]ASURION - Renewal Tracker[/TD]
[TD="align: right"]2193849338[/TD]
[TD]No[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD] >> Activations >> Verizon Wireless >> Features >> Features - No SPF[/TD]
[TD="align: right"]168533884[/TD]
[/TR]
[TR]
[TD]City[/TD]
[TD]New York[/TD]
[TD="align: right"]8/1/2017[/TD]
[TD]W1036IN15552[/TD]
[TD]John Smith[/TD]
[TD]Customer Name (differnet per invoice)[/TD]
[TD]CLVZRB002665[/TD]
[TD]TMP - NON ANDROID SMARTPHONE (NEW)[/TD]
[TD="align: right"]2193849338[/TD]
[TD]No[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD] >> Activations >> Verizon Wireless >> Features >> Features - SPF[/TD]
[TD="align: right"]168533884[/TD]
[/TR]
[TR]
[TD]City[/TD]
[TD]New York[/TD]
[TD="align: right"]8/1/2017[/TD]
[TD]W1036IN15552[/TD]
[TD]John Smith[/TD]
[TD]Customer Name (differnet per invoice)[/TD]
[TD]CLVZRB002671[/TD]
[TD]TMP - ANDROID SMARTPHONE (DROPPED)[/TD]
[TD="align: right"]2193849338[/TD]
[TD]No[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD] >> Activations >> Verizon Wireless >> Features >> Features - No SPF[/TD]
[TD="align: right"]168533884[/TD]
[/TR]
[TR]
[TD]City[/TD]
[TD]New York[/TD]
[TD="align: right"]8/1/2017[/TD]
[TD]W1036IN15552[/TD]
[TD]John Smith[/TD]
[TD]Customer Name (differnet per invoice)[/TD]
[TD]CLVZNS002316[/TD]
[TD]Installment Loan Number[/TD]
[TD="align: right"]1045546270[/TD]
[TD]No[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD] >> Activations >> Verizon Wireless >> Integration SKUs >> Other Installment SKUs[/TD]
[TD="align: right"]168533884[/TD]
[/TR]
[TR]
[TD]City[/TD]
[TD]New York[/TD]
[TD="align: right"]8/1/2017[/TD]
[TD]W1036IN15552[/TD]
[TD]John Smith[/TD]
[TD]Customer Name (differnet per invoice)[/TD]
[TD]CLVZNS002315[/TD]
[TD]Installment Financed Amount[/TD]
[TD="align: right"]2193849338[/TD]
[TD]Yes[/TD]
[TD="align: right"]-1[/TD]
[TD="align: right"]-760[/TD]
[TD] >> Activations >> Verizon Wireless >> Integration SKUs >> Installment Offset[/TD]
[TD="align: right"]168533884[/TD]
[/TR]
[TR]
[TD]City[/TD]
[TD]New York[/TD]
[TD="align: right"]8/1/2017[/TD]
[TD]W1036IN15552[/TD]
[TD]John Smith[/TD]
[TD]Customer Name (differnet per invoice)[/TD]
[TD]CLVZRB002318[/TD]
[TD]Installment Financing Fee[/TD]
[TD="align: right"]2193849338[/TD]
[TD]Yes[/TD]
[TD="align: right"]-1[/TD]
[TD="align: right"]-38[/TD]
[TD] >> Activations >> Verizon Wireless >> Integration SKUs >> Other Installment SKUs[/TD]
[TD="align: right"]168533884[/TD]
[/TR]
[TR]
[TD]City[/TD]
[TD]New York[/TD]
[TD="align: right"]8/1/2017[/TD]
[TD]W1036IN15552[/TD]
[TD]John Smith[/TD]
[TD]Customer Name (differnet per invoice)[/TD]
[TD]CLVZRB002317[/TD]
[TD]Installment Rebate Amount[/TD]
[TD="align: right"]2193849338[/TD]
[TD]No[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]760[/TD]
[TD] >> Activations >> Verizon Wireless >> Integration SKUs >> Other Installment SKUs[/TD]
[TD="align: right"]168533884[/TD]
[/TR]
[TR]
[TD]City[/TD]
[TD]New York[/TD]
[TD="align: right"]8/1/2017[/TD]
[TD]W1036IN15552[/TD]
[TD]John Smith[/TD]
[TD]Customer Name (differnet per invoice)[/TD]
[TD]FESFNS000035[/TD]
[TD]READY?GO! PACKAGE[/TD]
[TD="align: right"]2193849338[/TD]
[TD]No[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]24.95[/TD]
[TD] >> Fees >> Service Fees[/TD]
[TD="align: right"]168533884[/TD]
[/TR]
[TR]
[TD]City[/TD]
[TD]New York[/TD]
[TD="align: right"]8/1/2017[/TD]
[TD]W1036IN15552[/TD]
[TD]John Smith[/TD]
[TD]Customer Name (differnet per invoice)[/TD]
[TD]AYCSLI002440[/TD]
[TD]LIFEPROOF IPHONE 7 FRE SUNSET BAY[/TD]
[TD][/TD]
[TD]No[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]31.24[/TD]
[TD] >> Accessory >> Cases >> Rugged Cases[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]City[/TD]
[TD]New York[/TD]
[TD="align: right"]8/1/2017[/TD]
[TD]W1036IN15553[/TD]
[TD]John Smith[/TD]
[TD]Customer Name (differnet per invoice)[/TD]
[TD]AYPRWA000268[/TD]
[TD]W&A 2.4AMP WALLPORT[/TD]
[TD][/TD]
[TD]No[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]15.35[/TD]
[TD] >> Accessory >> Power >> Wallport >> Generic Wallports[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]City[/TD]
[TD]New York[/TD]
[TD="align: right"]8/1/2017[/TD]
[TD]W1036IN15553[/TD]
[TD]John Smith[/TD]
[TD]Customer Name (differnet per invoice)[/TD]
[TD]AYPRWA000266[/TD]
[TD]W&A 6FT LIGHTNING CABLE BLACK[/TD]
[TD][/TD]
[TD]No[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]24.02[/TD]
[TD] >> Accessory >> Power >> Cables >> Lightning Cables[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]City[/TD]
[TD]New York[/TD]
[TD="align: right"]8/1/2017[/TD]
[TD]W1036IN15554[/TD]
[TD]John Smith[/TD]
[TD]Customer Name (differnet per invoice)[/TD]
[TD]CLVZAP000208[/TD]
[TD]APPLE IPAD MINI RETINA 16GB SPACE GRAY (MF069LLA)[/TD]
[TD="align: right"]358849057012039[/TD]
[TD]No[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]-155.5[/TD]
[TD] >> Activations >> Verizon Wireless >> Equipment >> Tablets >> Apple Tablets >> Apple Tablets - New[/TD]
[TD="align: right"]165533960[/TD]
[/TR]
[TR]
[TD]City[/TD]
[TD]New York[/TD]
[TD="align: right"]8/1/2017[/TD]
[TD]W1036IN15554[/TD]
[TD]John Smith[/TD]
[TD]Customer Name (differnet per invoice)[/TD]
[TD]CLVZRB000399[/TD]
[TD]2 YR New iPad[/TD]
[TD="align: right"]4443411840[/TD]
[TD]No[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]200[/TD]
[TD] >> Activations >> Verizon Wireless >> Phone Rebates (VZ Commission) >> New Activation (VZ Commission)[/TD]
[TD="align: right"]165533960[/TD]
[/TR]
[TR]
[TD]City[/TD]
[TD]New York[/TD]
[TD="align: right"]8/1/2017[/TD]
[TD]W1036IN15554[/TD]
[TD]John Smith[/TD]
[TD]Customer Name (differnet per invoice)[/TD]
[TD]CLVZNS000066[/TD]
[TD]New Activation Rate Plan[/TD]
[TD][/TD]
[TD]No[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD] >> Activations >> Verizon Wireless >> Rate Plans[/TD]
[TD="align: right"]165533960[/TD]
[/TR]
[TR]
[TD]City[/TD]
[TD]New York[/TD]
[TD="align: right"]8/1/2017[/TD]
[TD]W1036IN15554[/TD]
[TD]John Smith[/TD]
[TD]Customer Name (differnet per invoice)[/TD]
[TD]CLVZRB000069[/TD]
[TD]New Activation (Rate Plan Rebate)[/TD]
[TD="align: right"]4443411840[/TD]
[TD]No[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD] >> Activations >> Verizon Wireless >> Rate Plan Rebates[/TD]
[TD="align: right"]165533960[/TD]
[/TR]
[TR]
[TD]City[/TD]
[TD]New York[/TD]
[TD="align: right"]8/1/2017[/TD]
[TD]W1036IN15554[/TD]
[TD]John Smith[/TD]
[TD]Customer Name (differnet per invoice)[/TD]
[TD]CLVZRB002692[/TD]
[TD]ASURION - 2 YR NEW SPF[/TD]
[TD="align: right"]4443411840[/TD]
[TD]No[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]60[/TD]
[TD] >> Activations >> Verizon Wireless >> Features >> Features - SPF[/TD]
[TD="align: right"]165533960[/TD]
[/TR]
[TR]
[TD]City[/TD]
[TD]New York[/TD]
[TD="align: right"]8/1/2017[/TD]
[TD]W1036IN15554[/TD]
[TD]John Smith[/TD]
[TD]Customer Name (differnet per invoice)[/TD]
[TD]CLVZNS002838[/TD]
[TD]VZW INSTANT DISCOUNT TABLET PROMO[/TD]
[TD][/TD]
[TD]Yes[/TD]
[TD="align: right"]-1[/TD]
[TD="align: right"]-100[/TD]
[TD] >> Activations >> Verizon Wireless >> Additional Spiffs (Promotions) >> REV Other VZ Promotions[/TD]
[TD="align: right"]165533960[/TD]
[/TR]
[TR]
[TD]City[/TD]
[TD]New York[/TD]
[TD="align: right"]8/1/2017[/TD]
[TD]W1036IN15554[/TD]
[TD]John Smith[/TD]
[TD]Customer Name (differnet per invoice)[/TD]
[TD]CLVZRB002839[/TD]
[TD]VZW INSTANT DISCOUNT TABLET PROMO GP[/TD]
[TD="align: right"]4443411840[/TD]
[TD]No[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]100[/TD]
[TD] >> Activations >> Verizon Wireless >> Additional Spiffs (Promotions) >> Other VZ Promotions[/TD]
[TD="align: right"]165533960[/TD]
[/TR]
[TR]
[TD]City[/TD]
[TD]New York[/TD]
[TD="align: right"]8/1/2017[/TD]
[TD]W1036IN15554[/TD]
[TD]John Smith[/TD]
[TD]Customer Name (differnet per invoice)[/TD]
[TD]CLVZRB002656[/TD]
[TD]TMP - BASIC/IPAD/JETPACK (NEW)[/TD]
[TD="align: right"]4443411840[/TD]
[TD]No[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD] >> Activations >> Verizon Wireless >> Features >> Features - SPF[/TD]
[TD="align: right"]165533960[/TD]
[/TR]
[TR]
[TD]City[/TD]
[TD]New York[/TD]
[TD="align: right"]8/1/2017[/TD]
[TD]W1036IN15554[/TD]
[TD]John Smith[/TD]
[TD]Customer Name (differnet per invoice)[/TD]
[TD]AYCSOT000336[/TD]
[TD]OTTERBOX IPAD MINI/2/3 PROFILE MOONLESS NIGHT[/TD]
[TD][/TD]
[TD]No[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]8.09[/TD]
[TD] >> Accessory >> Cases >> Folio Cases[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]City[/TD]
[TD]New York[/TD]
[TD="align: right"]8/1/2017[/TD]
[TD]W1036IN15554[/TD]
[TD]John Smith[/TD]
[TD]Customer Name (differnet per invoice)[/TD]
[TD]FESFNS000035[/TD]
[TD]READY?GO! PACKAGE[/TD]
[TD="align: right"]4443411840[/TD]
[TD]No[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]24.95[/TD]
[TD] >> Fees >> Service Fees[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


What i need to look like:

Invoice W1036IN1554 and all related data listed on a single row.
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
Sort by date Sort by votes
Not easily or that I'm aware of, hopefully others reading this thread can suggest?
 
Upvote 0
You must log in or register to reply here.

Similar threads

F
  • Solved
Filter leaves last row of data visible regardless of what is filtered
Replies
2
Views
740
frank_AL
F
G
  • Question Question
Two Different Workbooks Receive Data From Columns If Row A Matches
Replies
0
Views
374
gjfood
G
F
  • Question Question
Custom search bar - Creating a front end for My Sold Research Tool.
Replies
0
Views
204
frewert
F
P
  • Question Question
VBA for sending rows of data if column A = current date. (Via email)
Replies
1
Views
732
paun_shotts
P
D
  • Question Question
Move data from one sheet to mutlipe sheets based on sheet name
Replies
3
Views
678
Herakles
H

Forum statistics

Threads
1,223,909
Messages
6,175,314
Members
452,634
Latest member
cpostell

Share this page

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