Forum Discussion
renjie0315
Feb 18, 2023Copper Contributor
VLookup with Comma Interval
Hi all, I would like to use VLookup to abstract the phone number and email based on the name given in cell B3 and subsequent column. However, in between the name, there is a comma, may I know is...
FikturFox
Feb 20, 2023Brass Contributor
renjie0315
Perhaps with M365...
=SORT(UNIQUE(WRAPROWS(TOCOL(WRAPCOLS(TOCOL(TEXTSPLIT(TEXTJOIN("♡",1,B3:D4),{"♡",", "})),2),,FALSE),3)))