Google sheet formula required.

Before we proceed with this, please update your forum profile as I requested in your previous thread.

Please also review the forum guidelines on thread titles, which should not be generic.

Finally, for GS queries, you need to provide a LINK to an editable GoogleSheet, not an Excel file.

Hi Mam,
Changed the profile name to Google sheets and adding a link of google sheet here:
https://docs.google.com/spreadsheets...it?usp=sharing

Please help me on it

Thanks - your thread title ought to be improved.

I can't help - sorry. Someone who uses GS will. Please be patient and remember it's a weekend, so footfall here is lower.

You have ignored my comments about the thread title, which remains generic. You will most likely get better responses if the thread title describes the problem.

In Excel 365:

=LET(s,SEQUENCE(1,7,C11,1),e,IF(s<>"","",""),TOROW(VSTACK(s,e),0,1))

Your GS is View Only - you need to provide write access.

For GS:

=ARRAYFORMULA(LET(s,SEQUENCE(1,7,C11,1),e,IF(s<>"","",""),TOROW(VSTACK(s,e),0,1)))

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED. You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.

Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

Slight variation on the mechanism to get the blank cells in Ali's formula*, and slightly shorter.

Formula:

Please Login or Register  to view this content.

* Learning lots today 👍

That's a nice trick - I'll be pinching that one!

If we're playing the "Mine's shorter than yours" game:

=LET(s,SEQUENCE(,7,C11),TOROW(VSTACK(s,T(+s)),,1))

Nice and compact.

What else can one do on a cold, wet and windy summer's day (feels more like autumn)?

EDIT: Would be nice if the OP would bother to acknowledge these suggestions, all of which they've seen.

I'm on the Crozon peninsula, in Brittany... freezing cold, windy and tipping it down outside.

Well, you don't need to go to Brittany to get that. Staying at home trying to stop the squirrels getting onto the bird feeders.

If we're playing the "Mine's shorter than yours" game:

Guessing not a phrase you'll hear often. But, no, that wasn't the specific intent. Just exploring options (primarily because an IF that could only return null values seemed an odd construct).

because an IF that could only return null values seemed an odd construct

But it did the job, albeit not as elegantly as T(+s)!!!

Please don't forget the other contributors!

But it did the job, albeit not as elegantly as T(+s)!!!

Well, we now have three ways to do the job. Always good to have options . Good working with you

You're welcome. Thanks for letting us know that you got an answer.

---

Please take a moment and consider clicking the "Add Reputation" button at the foot of any of the posts of anyone who helped you reach a solution here today.

Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.

Thanks for the rep.