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 !!

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 125 20003 Mary Ann Services Maintenance 12 Maintenance colour 7 280 Gloss 17 Colour gloss 2 50 19 EXPRESS Gloss 8 200 40267 Craig Sapu Services Maintenace 10 Maintenace format 2 70 12 Maintenance colour 2 80 Gloss 17 Colour Gloss 1 25 Items Products 15.0001 Express paint 1 12.5

Explanation / Answer

Hi..

I still have no idea how your data relates to that. How does this become what you want?

Navigate

Transposable elements: If the sequence of a DNA template strand is GGCCAATT, wha

Transposons are movable elements of DNA that insert into new positions within th

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.

Transposing data Hi, I imported data from external database and it\'s a mess....

Question

Explanation / Answer

Related Questions

Navigate