Data is spread in multiple rows, need to put into tabular format
Hi all,
Stuck on a problem and not sure what the correct terms are in order to search the answer.
I have a table with data in a journal style with duplicate lines for each product the customer has bought ie this.
CustomerDateProduct SoldPriceSam01/01/2024Watch£50.00Sam01/01/2024Bike£100.00Fred03/03/2024Bike£100.00Fred03/03/2024Watch£399.00Fred03/03/2024Jacket£300.00Peter03/03/2024Bike£100.00Jane03/03/2024Watch£50.00Jane03/03/2024Pen£100.00Dave09/01/2024Watch£75.00Dave09/01/2024Jacket£300.00Steve11/01/2024Watch£50.00Steve11/01/2024Jacket£300.00Steve11/01/2024Bike£100.00
What I need to get to is the data with one line per customer record, showing all products bought.
CustomerDateWatchBikeJacketPenSam01/01/20245010 Fred03/03/2024399100300 Peter03/03/2024 100 Jane03/03/202450 100Dave09/01/202475 300 Steve11/01/2024 100
What is the best way to achieve this please 🙂
Hi all, Stuck on a problem and not sure what the correct terms are in order to search the answer. I have a table with data in a journal style with duplicate lines for each product the customer has bought ie this. CustomerDateProduct SoldPriceSam01/01/2024Watch£50.00Sam01/01/2024Bike£100.00Fred03/03/2024Bike£100.00Fred03/03/2024Watch£399.00Fred03/03/2024Jacket£300.00Peter03/03/2024Bike£100.00Jane03/03/2024Watch£50.00Jane03/03/2024Pen£100.00Dave09/01/2024Watch£75.00Dave09/01/2024Jacket£300.00Steve11/01/2024Watch£50.00Steve11/01/2024Jacket£300.00Steve11/01/2024Bike£100.00 What I need to get to is the data with one line per customer record, showing all products bought. CustomerDateWatchBikeJacketPenSam01/01/20245010 Fred03/03/2024399100300 Peter03/03/2024 100 Jane03/03/202450 100Dave09/01/202475 300 Steve11/01/2024 100 What is the best way to achieve this please 🙂 Read More