Hi - I've been trying to solve this for day and can't find anything that helps besides doing it manually which takes hours.
In my data set I have Master Names for portfolios and anywhere from 1-50 tickers that correspond underneath. What I need is to return all the tickers for each portfolio in one row separated by commas. The only thing I can figure is to use a series of concatenate formulas but seeing as my data set in close to 3000 rows this takes me quite some time. Is there any code I can use or some function that I'm not aware of to do this?
Thanks so much in advance for your help!
Bookmarks