Transposing data Hi, I imported data from external database and it\'s a mess....
ID: 640624 • Letter: T
Question
Transposing data
Hi, I imported data from external database and it's a mess.... I need to organize it so at least I can filter data and analyse it. Essentially I need to see what client bought what product and how much it cost. The category (product or service) can be removed. Not relevant. (last line is a product code - Service codes are simple numbers product codes are just plain idiotic!
Thanks !!
Explanation / Answer
Hi..
I still have no idea how your data relates to that. How does this become what you want?
A B C D Cod (Client; product) Details Quant Price 20001 John Smith Services Maintenance 12 Maintenance colour 4 160 Gloss 17 Colour gloss 2 50 19 EXPRESS Gloss 2 50 Specials 37 Month special 1 35 20002 Peter Hill Services Gloss 17 Colour gloss 1 25 19 EXPRESS Gloss 5 125Related Questions
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.