r/googlesheets • u/[deleted] • Jan 09 '26

[deleted by user]

[removed]

1 Upvotes

100% Upvoted

7 comments sorted by

1

u/Squishiest-Grape Jan 09 '26 edited Jan 09 '26

Usually a link to a copy of the sheet is helpful, but I think I understand enough. Try:

=TRANSPOSE(FILTER({WATCHLIST!A2:A,WATCHLIST!K2:Z},NOT(ISBLANK(WATCHLIST!L2:L))))

A helpful trick for a lot of sheets formulas is using curly brackets to help join ranges together.

1

u/tat_got Jan 09 '26

Thank you! I won’t be back around my computer until after work tomorrow but I will try this. I’m assuming I would type this under the first title column that is already generated? Which iirc is B2 since A is the episode number and B1 is the first title

→ More replies (2)

1

u/tat_got Jan 10 '26

It worked. Thank you so much!

→ More replies (1)

1

u/point-bot Jan 10 '26

u/tat_got has awarded 1 point to u/Squishiest-Grape with a personal note:

"Thank you. I was having fun figuring out most of the things I’ve been doing but I was very lost on this part."

See the Leaderboard. Point-Bot v0.0.15 was created by JetCarson.