Hi Everyone!
I have a very large data set showing lists of different airlines that customers have taken in the last year. How do I create an aggregate report of each customer's airline history? I attached an example of the data set that I'm working with.
NOTE: The database of records might have different variations of a customer's name, company & email address but it's easy to see it's the same individual.
Any insight that can be provided would be great.
Thanks!
ok, what do you want to do with it?
Name Company Name Email Address Airlines Used in 2022 John Smith Main Street Inc. [email protected] Delta John K. Smith Main Street Inc. [email protected] American John Smith Main Street Inc. [email protected] United Maggie Jones West Corp [email protected] Spirit Maggie Thomas-Jones West Corporation [email protected] American Maggie Jones West Corporation [email protected] Delta Maggie Jones West Corporation [email protected] South West Maggie Jones West Corporation [email protected] Alaska James "Jim" Thomas East Company [email protected] Alaska James Thomas East Company [email protected] Delta
any expected result?
I'd like to create an aggregate report that outlines each customer's airline history. I attached the original data set and the final version of the summarized report that I'd like to create.
Are there any formulas that I can use to create a spreadsheet that shows a summary of each person's airline history?
Thanks in advance.
Last edited by dakkota; 01-28-2023 at 09:36 AM.
Re: Aggregate Report for large Dataset
something like this?
Yes, that's exactly what I'm truing to accomplish. Is there a specific formula or function that you used to create the report?
this is just Pivot table
Insert tab
or
Alt N V
Last edited by sandy666; 01-28-2023 at 05:07 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks