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 Google Sheets Tips newsletter #386, your Monday morning espresso, in spreadsheet form! Similar to Sheets Tip #384 from a couple of weeks ago, we're keeping it light hearted with today's tip. In this case, I'm showing you one of Google Sheets' secret easter egg functions! Read on to find out what it is and what it does. ➜ Sheets Tip #386: Is your Sheet feeling crowded? Build a meadow 🐑 We’ve all been there: you’re focused on giving a demonstration in your Sheet to...
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #385, your Monday morning espresso, in spreadsheet form! It's that time of year when you need hat and gloves one day and shorts and sunscreen the next. Last week, we had back-to-back days of 90°F. I'm sure it happens every Spring, but I always find it surprising how quickly the seasons change. Thankfully, we've also enjoyed plenty of days in the 60s and 70s (the preferred operating temperature of this Englishman). I...
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #384, your Monday morning espresso, in spreadsheet form! Normally with these Google Sheets Tips, I make them as practical as possible, so that you can apply them to your work. Today, however, I'm going to show you The Ultimate Spreadsheet Prank as a way of understanding how custom number formats work. And if that doesn't float your spreadsheet boat, well then, I don't know what will. Find this tutorial below the news...