Get better at working with Google Sheets! Join 50,000 readers to get an actionable tip in your inbox every Monday.
Sheets Tip 366: Stack lists with the magic of TOCOL
|
Welcome to the Google Sheets Tips newsletter #366, your Monday morning espresso, in spreadsheet form! ➜ NewsI. II. ➜ Sheets Tip #366: Stack lists with the magic of TOCOLSuppose we have lists of names like this: In this example, there are 4 columns of names, of varying lengths. How can we combine them quickly and easily into a single list? Enter TOCOL. The TOCOL function flattens a range into a single column. It's like the FLATTEN function but has the advantage that you can specify whether to ignore blank cells. In our example, this formula ignores all the blank cells: =TOCOL(A1:D9,TRUE) A1:D9 is the range of the 4 columns. The second argument, TRUE, is us telling the TOCOL function to ignore the blanks. (Set it to FALSE or omit it if you want to keep the blanks.) Here it is in our Sheet: Easy! If you enjoyed this newsletter, please forward it to a friend who might enjoy it. Have a great week! Cheers, |
Google Sheets Tips
Get better at working with Google Sheets! Join 50,000 readers to get an actionable tip in your inbox every Monday.
Brought to you by: Hi Reader, Happy New Year! 🎉 Welcome to the Google Sheets Tips newsletter #371, your first Monday morning espresso of 2026, in spreadsheet form! I usually write a year-in-review post over the holidays but this holiday was so busy that I didn't get round to it. It's a valuable exercise to reflect on the year gone and think about what I want to achieve this year. So I'm still planning to write one and will share it when I do. I hope you had a wonderful holiday season and feel...
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #370, your Monday morning espresso, in spreadsheet form! This is the last Google Sheets Tips email for 2025. We're taking a break from publishing for the holidays and will return with Tip 371 on 5th January 2026. Thank you so much for reading and replying to these emails. I love learning from all of you when you write back and share your own tips and tricks (and occasional corrections! 😉 ). In the meantime, I wish you...
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #369, your Monday morning espresso, in spreadsheet form! We had our first snowfall of the season last Friday, so winter is definitely underway here in the Mid-Atlantic region. It was only a light dusting though, so the sleds are still hanging in the garage. For now. In this issue, we're looking at a clever way to add visual clues to our data tables with indicator arrows ▲🔻. And, if you're a Workspace customer, you must...