Transforming a customer record (one row) into a list of invoice items

Occasional Visitor

I am downloading a spreadsheet file from a website database.  Each row is a customer/transaction record: the customer's contact info, payment amount and method, and in a series of fields (columns) what the customer purchased -- say, a book, a knife, a ticket to Paris, most represented by two fields (item and quantity).


What I am aiming at is to transform each such customer/transaction row into a list of purchases, that is, several rows for each customer: customer/transaction id, item purchased.  All in a long table of purchases for all customers/transactions.


For some reason, my mind is really struggling with how to get from where I am (a list of customer transactions) to a list of items purchased tagged with a customer/transaction id.  I am drawing a blank on a strategy and am hoping that someone can point me in the right direction. 



1 Reply
Attach your file along with the specific scenario of the result you want to achieve.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies