Forum Discussion
Access Analytic Power Query challenge: Ticket list
Power Query Challenge - Ticket List - Access Analytic Every now and then, I like to try one of Wyn Hopkins PQ challenges, just to make sure I can perform the same task in regular Excel. The prob...
I hadn't noticed before TOCOL has a setting to ignore errors which might be of use here,
=LET(
i, SEQUENCE(, MAX(number), 0),
tickets, TEXTBEFORE(range, "-") + i / (i < number),
HSTACK(
TOCOL(IF(tickets, name), 2),
TOCOL(tickets, 2)
)
)