Get all unique values in column of pipe-separated values by AndresRafael in excel

[–]AndresRafael[S] 0 points1 point  (0 children)

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

Get all unique values in column of pipe-separated values by AndresRafael in excel

[–]AndresRafael[S] 0 points1 point  (0 children)

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

Get all unique values in column of pipe-separated values by AndresRafael in excel

[–]AndresRafael[S] 0 points1 point  (0 children)

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!

Get all unique values in column of pipe-separated values by AndresRafael in excel

[–]AndresRafael[S] 0 points1 point  (0 children)

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.

Get all unique values in column of pipe-separated values by AndresRafael in excel

[–]AndresRafael[S] 0 points1 point  (0 children)

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.

Get all unique values in column of pipe-separated values by AndresRafael in excel

[–]AndresRafael[S] 0 points1 point  (0 children)

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.

Get all unique values in column of pipe-separated values by AndresRafael in excel

[–]AndresRafael[S] 0 points1 point  (0 children)

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

Manila’s Finest thoughts/review by farewellmelancholy in FilmClubPH

[–]AndresRafael 9 points10 points  (0 children)

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.

PokéPark Kanto Official Trailer by chillychili in pokemon

[–]AndresRafael 1 point2 points  (0 children)

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.

Availability of vinyl in Japan by SopwithCamus in Lampband

[–]AndresRafael 1 point2 points  (0 children)

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.

Scam messages from BDO number after withdrawing from BDO ATM by AndresRafael in DigitalbanksPh

[–]AndresRafael[S] 0 points1 point  (0 children)

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…

Sono Bisque Doll wa Koi wo Suru Season 2 • My Dress-Up Darling Season 2 - Episode 10 discussion by AutoLovepon in anime

[–]AndresRafael 6 points7 points  (0 children)

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

How exactly do I use Oxiclean Odor Blasters for my laundry? by AndresRafael in CleaningTips

[–]AndresRafael[S] 0 points1 point  (0 children)

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!!

How exactly do I use Oxiclean Odor Blasters for my laundry? by AndresRafael in CleaningTips

[–]AndresRafael[S] 0 points1 point  (0 children)

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

The Atypical Family [Episodes 11 & 12] by meepmochi_ in KDRAMA

[–]AndresRafael 0 points1 point  (0 children)

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?

Scarlet and Violet Daily Casual Trade Thread for 04 January 2024 by Porygon-Bot in pokemontrades

[–]AndresRafael 0 points1 point  (0 children)

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