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.
Hi Reader, Welcome to the Future Proof #3 (formerly the Google Sheets Tips newsletter), your Monday morning espresso, in AI form! Here in the Mid-Atlantic region, fall has arrived with cooler temperatures, blustery winds, and grey, rainy days. (As a Brit, it makes me feel right at home!) That means it's officially the end of the shorts-as-the-default-choice season. And, there's a riot of color coming our way over the next few weeks as the maple trees put on a show 🍁. Today, I'm sharing a tip...
Hi Reader, Welcome to the Future Proof #2 (formerly Google Sheets Tips), your Monday morning espresso, in AI form! Sorry this second issue is a day late. I was really sick at the end of last week and over the weekend, so even though the newsletter was largely written, I wasn't well enough to write this intro and press send yesterday. So, here it is. Thanks for all the kind responses last week when I introduced the new format. It seems like the majority of you understand the pivot and are...
Hi Reader, Welcome to Future Proof (formerly the Google Sheets Tips newsletter), your Monday morning espresso, in spreadsheet AI form! I published the first Google Sheets Tips newsletter in April 2018, a lifetime ago in technology terms. The mission was simple: one practical, actionable lesson each week to help you work more effectively. That mission hasn't changed. Lately though, more and more of you are turning to AI to get things done. And if you're anything like me, you're finding that...