Hi,
I have data from a report I pulled from our ERP system. Its customer purchases data. I want to rearrange it for better analysis, but want to know if there is a better way to do it.
The report leaves alot of blank spaces which makes it hard to filter through. I've been manually cutting/pasting in rows and deleting rows to bring the data together, but 16000 rows is quite alot. Was wondering if there is a better way to do it?
Below is what I have and what I want:
WHAT THE REPORT GIVES ME:
WARD PRANDON 901-591-7998
Date Brand Style Description Qty Total Reg Mkdn BuyClub BuyClub
7/17/2016 JAYMY INC 6299 J AYMY 1 11.99 4.00 0.40 0.00
7/17/2016 FOCUS JEANS 6002B MOTO RIPS 1 29.99 0.00 0.99 0.00
2 41.98 4.00 1.39 0.00
WARE KIMAL 870-514-3056
Date Brand Style Description Qty Total Reg Mkdn BuyClub BuyClub
7/28/2016 RISE AS ONE EF6107K KIDS SHIRTS 1 21.99 0.00 0.73 0.00
7/28/2016 POLO RL 320581436001 BASIC MESH-BANNER 1 9.99 29.51 0.33 0.00
7/28/2016 POLO RL 312560942006 CORDUROY-SKIl 1 9.99 35.01 0.33 0.00
3 41.97 64.52 1.39 0.00
WHAT I WANT:
LAST N FIRST N PHONE NUMBER Date Brand Style Description Qty Total RegMkdn BuyClub BuyClub
WARD JAVANTEZ 662-544-0541 7/3/2016 JAYMY INC 501 JAYMY 1 20.99 0.00 0.69 0.00
WARD JAVANTEZ 662-544-0541 7/3/2016 STEAL DEAL TH-RETRO RETRO KICKS 1 9.99 5.00 0.33 0.00
WARD JAVANTEZ 662-544-0541 7/3/2016 EVOLUTION 11100A MEN'S BLEACH WOVEN 1 9.99 35.00 0.33
WARD JAVANTEZ 662-544-0541 totals 3 40.97 40.00 1.35 0.00
Bookmarks