Creating multiple columns for different values in 1 single row

Asked Apr 15 '21 at 20:18

Active Apr 15 '21 at 20:36

Viewed 24 times

this is pretty simple and I can't get my head around how to do it! I'm trying to do a:

=TEXTJOIN(", ",TRUE,G:G)

But not sure how to group it by business.

In excel, I have a data set which is like the below:

But for each of these businesses, I need to convert it to this:

Business	Location
Mary's	United Kingdom, United States, Canada
Bill's	Bolivia, Canada
Adam's	Iceland, United States

Can anyone give any tips?

Thanks!

edited Apr 15 '21 at 20:36

Scott Craner

asked Apr 15 '21 at 20:18

dbhc5521

`TEXTJOIN`........ – BigBen Apr 15 '21 at 20:19
Thanks - I'm trying to use that but because I have a massive dataset with different numbers of locations it's not working how I'd expect it to. That's fine for this example but to try use it against 10000ish rows it's not producing the right results? – dbhc5521 Apr 15 '21 at 20:23
You will need to do it in two steps, fist get the unique list then use textjoin on that unique list. – Scott Craner Apr 15 '21 at 20:26
Thanks - I've edited with a bit more info. I'm used to working with SQL if that's any easier? – dbhc5521 Apr 15 '21 at 20:32
1

Look into Powerquery. – JvdV Apr 15 '21 at 20:35
1

`=TEXTJOIN(", ",TRUE,FILTER(G:G,F:F="Mary's"))` – Scott Craner Apr 15 '21 at 20:36
https://stackoverflow.com/q/60772285/9758194 – JvdV Apr 15 '21 at 20:38
The PowerQuery worked excellently, and now I know something new! Thanks for all that suggested and thanks for the link! :) – dbhc5521 Apr 15 '21 at 21:20

0 Answers0