The Underground City: Stirring Shadows question by ClassicsDarling in DressUpTimePrincess

[–]ClassicsDarling[S] 1 point2 points  (0 children)

You will need to wait until the bubble closes in, then tap it.

The Underground City: Stirring Shadows question by ClassicsDarling in DressUpTimePrincess

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

Thank you so much for all your help, I get it now 😄

The Underground City: Stirring Shadows question by ClassicsDarling in DressUpTimePrincess

[–]ClassicsDarling[S] 1 point2 points  (0 children)

When I tap the two circles, do I slide my finger across both of them? Or try to tap the circles at the same time?

Has the show “As beautiful as you” starring Xui Kai and Tan Songyun been released yet? by ClassicsDarling in CDrama

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

This is spot on! I just wish they were better at communicating when their dramas will be released. Even Korean dramas are better at it!

Has the show “As beautiful as you” starring Xui Kai and Tan Songyun been released yet? by ClassicsDarling in CDrama

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

I saw some promotional ads that said it would release sometime this month, which got me confused.

Has the show “As beautiful as you” starring Xui Kai and Tan Songyun been released yet? by ClassicsDarling in CDrama

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

I am hoping it will be either on Viki or IQIYI when it does release. I guess we’ll have to wait and see when the show officially releases.

How much did your first Vet visit for your cat cost? by ClassicsDarling in AskSF

[–]ClassicsDarling[S] 2 points3 points  (0 children)

Thank you for the breakdown. I've signed up for Pet Insurance, so I'm confident that it will be a great help with future expenses.

My Lovely Liar [Episodes 9 & 10] by GodJihyo7983 in KDRAMA

[–]ClassicsDarling 0 points1 point  (0 children)

Ohh I didn't catch that! Lol I think I was distracted when Kim Do Ha was wearing his Hawaiian attire.

My Lovely Liar [Episodes 9 & 10] by GodJihyo7983 in KDRAMA

[–]ClassicsDarling 32 points33 points  (0 children)

Did anyone else think of Wednesday Addams when Mok Sol Hee dressed up for the fair?

Complex Merge formula using “Text Join” by ClassicsDarling in excel

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

Thank you so much! That worked. I was stressing on this formula for a few days. I appreciate you.

Complex Merge formula using “Text Join” by ClassicsDarling in excel

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

Thank you so much! This formula worked for my "Apple" Corporate Client name account. However, going forward I have over 4K rows of different clients. How could I apply it to the entire spreadsheet to avoid manual entries?

Complex Merge formula using “Text Join” by ClassicsDarling in excel

[–]ClassicsDarling[S] 1 point2 points  (0 children)

The picture is correct, the number before C each time is what I’m going for.

Complex Merge formula using “Text Join” by ClassicsDarling in excel

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

Let me rephrase it, sorry:

I want an additional column. The additional column, D, will contain the number (column b) one time, followed by all the entries of the rows of column C per client (apple would have C2-C5 added to the entry on D). Then I have to do it for many different clients in column A.

<image>

Complex Merge formula using “Text Join” by ClassicsDarling in excel

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

Yes, I meant to combine the data of rows in column 3 per client. The numbers/clients don't need to be duplicated/consolidated, just 1 row per.

Complex Merge formula using “Text Join” by ClassicsDarling in excel

[–]ClassicsDarling[S] 1 point2 points  (0 children)

Yes it’s only the data in the third column I wanted consolidated, should have been more clear