I'm loving the built in filter functions in 365 but was hoping to find a similar one to extract values and stacking them.
I would like to pull names in each cell of Data table, which are separated by ";", and stack them separately in another column. I want to avoid using power query for a particular reason so was hoping to find a Filter or Array function........
Data table is raw data. Output table is my desired results.
Thanks
If the order is not important …
Formula:
Please Login or Register to view this content.
This formula MUST NOT be next to the Table. There must be at least one blank column between the Table and the formula output.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
If you want them in the same order as your sample output, you could use something like:
=TOCOL(REDUCE("Name",Data[Names],LAMBDA(a,b,VSTACK(a,TEXTSPLIT(b,";")))),2,TRUE)
Rory
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks