Wyn Ticket Challenge - Oz du Soleil

This video includes the weaving together of 7 dynamic array functions in the creation of a solution.

Wyn Hopkins, fellow Microsoft Excel MVP, presented a challenge recently:
If you have a list of people and their ticket numbers:
Lisa Tickets: 300-303
KC Tickets 390-390
Aaron Tickets 772-778
How can you get a list of the individual ticket numbers alongside the name of the ticket holders? E.g. 4 rows for Lisa with tickets 300, 301, 302, 303.

I show you a solution using:
FILTER, SEQUENCE, TOCOL, TEXTBEFORE, TEXTAFTER, HSTACK, VSTACK

For a list of my Excel courses at Lynda/LinkedIn:
https://www.linkedin.com/learning/instructors/oz-du-soleil
There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.

Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 3rd Edition
https://www.mrexcel.com/products/guerrilla-data-analysis-3rd-edition/
My old blog: http://datascopic.net/blog-2-2