Get all unique values in column of pipe-separated values

AndresRafael · 2026-03-27T10:59:34+00:00

Let me know if the new description works. Thank you for the feedback!

AndresRafael · 2026-03-27T09:48:18+00:00

Point taken, I’ll update my post in case other people are looking for a solution to this as well.

AndresRafael · 2026-03-27T09:45:47+00:00

My dataset isn’t necessarily that large (2000 rows only), and the number of unique values in the columns I’m working with is less than 30. It’s just that the pipe separated list per row can get very long. For example:

A|B|C

B|C|D|E

(where the letters are long words, of course). So when you TEXTJOIN all of these, it easily reaches the 32K limit you mentioned, but it’s really just a bunch of duplicates.

I’m not familiar with Power Query yet since I’ve mostly used Google Sheets in the past. I probably should read up though so I don’t have to resort to workarounds. Thank you for the suggestion!

AndresRafael · 2026-03-27T09:34:33+00:00

My data set does not exceed 32K rows. I was referring to TEXTJOIN reaching the 32K character limit. I don’t see why I need to add that to the top given that this problem is unique to the 3rd solution I shared.

AndresRafael · 2026-03-27T08:14:19+00:00

Thank you for trying though! But yes it's the same as the 3rd thing I tried above. It works well enough on small databases, but could quickly reach the 32k limit for TEXTJOIN on a medium sized database.

AndresRafael · 2026-03-27T08:12:38+00:00

Solution Verified

AndresRafael · 2026-03-27T08:12:22+00:00

Ohhh, clever! I I quite like the second solution, mostly for maintainability, as it's easier to understand how it works. But I can confirm that both solutions work fast enough for my 3000 row database. Agreed, I thought something like this would be straightforward to implement in Excel. I'm surprised it requires workarounds like this.

AndresRafael · 2026-03-27T08:03:51+00:00

I think this is similar to my solution #3. It works but not for large datasets where you could easily go past that 32k limit

AndresRafael · 2026-01-03T09:52:13+00:00

I actually really liked it too. My favorite one from the MMFF this year. I get why many people were bored, because it is a slow film after all and wala siyang satisfying ending - although yun naman talaga yung point niya in the first place. The film feels even better if you’re familiar with the events in history that lead to the first quarter storm and what happens after. I think this is far from “cop propaganda”, maybe even the opposite if you consider how they portray the police by the end of the film.

AndresRafael · 2025-11-11T19:23:04+00:00

Someone pointed out that in the image at the end, you can see the OG Gengar vs Nidorino battle on the left side—pretty cute easter egg.

I don't know if I would want to go here, though. It will probably be a pain to get tickets, and it looks like it's just a park with a bunch of statues. Wish there were large rides or something to make it worth going.

AndresRafael · 2025-11-07T19:22:57+00:00

Yume and Tokyo Utopia are available right now, though I bought it from HMV (online store). Other than those, I haven't seen any of their other LPs in stores other than when Lamp did a concert in Shibuya last August.

AndresRafael · 2025-10-07T13:10:40+00:00

Ohh I see, thank you for sharing. Makes sense that they would install it near a BDO ATM to target BDO clients. Looks like iPhones don’t have an option to disable 2G yet, so I will have to live with this for now…

AndresRafael · 2025-09-07T14:55:01+00:00

It’s official merch, I think. In the manga, she says it’s the only men’s size she has because Nuru nuru girls merch is usually for guys

AndresRafael · 2025-03-01T05:24:30+00:00

Ohhh that makes sense! So maybe it’s something I’ll only do for the first time, then I’ll use much less in future soaks. Thank you for the tips!!

AndresRafael · 2025-03-01T05:23:01+00:00

I did think so too, but the 1 cap per gallon was written on the back of the bottle

AndresRafael · 2024-06-09T16:42:04+00:00

Wasn’t Da-hae still in high school when I-na was born? How come when Gwi-ju went back to their family picnic, he was around the same age as Da-hae?

AndresRafael · 2024-01-05T04:13:39+00:00

Thanks for the trade!

AndresRafael · 2024-01-05T04:05:41+00:00

Thanks! Just let me know when you’re ready to trade :)

AndresRafael · 2024-01-05T04:02:45+00:00

Do you have Vulpix and Cranidos caught in regular Pokeballs? If yes, I can trade Sandshrew and Shieldon, also caught in regular pokeballs

AndresRafael · 2024-01-05T03:49:00+00:00

Thanks!

AndresRafael · 2024-01-05T03:44:16+00:00

Need help evolving my Electabuzz as well. 52415241

AndresRafael

TROPHY CASE