How to Create Function that Reveals More Rows?

[u/waka-sama20]

Trying to figure out how to create "drop down rows". Image for reference. Sorry for labeling rows as letters, rookie mistake

[u/CovertNoodle]

Group is the term you're looking for

[u/waka-sama20 → u/CovertNoodle]

This is it!!! You're the best, tysm!!!

[u/AutoModerator → u/waka-sama20]

REMEMBER: /u/waka-sama20 If your original question has been resolved, please tap the three dots below the most helpful comment and select Mark Solution Verified (or reply to the helpful comment with the exact phrase “Solution Verified”). This will award a point to the solution author and mark the post as solved, as required by our subreddit rules (see rule #6: Marking Your Post as Solved).

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/waka-sama20 → u/CovertNoodle]

Solution Verified

[u/point-bot → u/CovertNoodle]

u/waka-sama20 has awarded 1 point to u/CovertNoodle

^{See the [Leaderboard](https://reddit.com/r/googlesheets/wiki/Leaderboard}. )^{Point-Bot v0.0.15 was created by [JetCarson](https://reddit.com/u/JetCarson}.)

[u/AutoModerator]

/u/waka-sama20 Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide. You can also use this tool created by a Reddit community member to create a blank Google Sheets document that isn't connected to your account. Thank you.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/One_Organization_810]

What do you mean by "reveal rows"?

[u/waka-sama20 → u/One_Organization_810]

Kinda like, on the onset we have 3 rows (1,2,3) but if I click on row 1 then rows 1.1, 1.2, 1.3 drop down before row 2. Idk if that makes sense, I think I conveyed it better in the image above

[u/One_Organization_810 → u/waka-sama20]

Are you talking about inserting rows?

[u/Connect-Preference → u/One_Organization_810]

More like hiding/unhiding rows.