I am working on a report that I'd like to automate and I need a little help.
In column A, I have a Name.
In column E, I have a six digit number (called a ticket).
In column F, I have a three digit number that is unique to the number in column E (called a SubTicket).
What I need is:
The Name to appear only once (still in column A)
The amount of Subtickets each Name has (placed in column D)
The actual tickets associated with each name listed all in one cell in column G
I have attached an example sheet.
Sheet1 has the raw data
Sheet2 has what I need it to look like.
Any help is greatly appreciated.
Thanks in advance!