Actually, Google Sheets.
I have a Google Sheet generated through a Google Form, i.e., each row is a form submission.
Each submission includes (among other data) the submitter's last name, first name, email address and then, let's call it "unique order". Some people submit more than once, depending on how many unique orders they have. So, for example, one day a person submits a unique order "hamburger," the next day they submit a unique order, "hot dog".
What I would like to do is generate a secondary sheet, with a single row for each unique email address, and with the following columns:
Last Name, First Name, Email, Unique Order 1, Unique Order 2, Unique Order 3, Unique Order 4, where each "Unique Order" comes from a different row (different submission) on the initial sheet.
The problem is that I am an Excel novice, and this seems to be a sophisticated Excel problem.
Any suggestions? (Hire someone who knows how to program Excel?)
I have a Google Sheet generated through a Google Form, i.e., each row is a form submission.
Each submission includes (among other data) the submitter's last name, first name, email address and then, let's call it "unique order". Some people submit more than once, depending on how many unique orders they have. So, for example, one day a person submits a unique order "hamburger," the next day they submit a unique order, "hot dog".
What I would like to do is generate a secondary sheet, with a single row for each unique email address, and with the following columns:
Last Name, First Name, Email, Unique Order 1, Unique Order 2, Unique Order 3, Unique Order 4, where each "Unique Order" comes from a different row (different submission) on the initial sheet.
The problem is that I am an Excel novice, and this seems to be a sophisticated Excel problem.
Any suggestions? (Hire someone who knows how to program Excel?)