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 #394, your Monday morning espresso, in spreadsheet form. Welp, with the World Cup and the Tour de France events both now firmly in the rear view mirror, I guess I have no choice but to get back to work! In all seriousness, this summer has been crazy busy for me. International travel to visit my family in England, a bad sickness, summer camps, moving house... Once my boys go back to school again, it'll be a little easier to get into a...
Hi Reader, Welcome to the Google Sheets Tips newsletter #393, your Monday morning espresso, in spreadsheet form! ⚽️ We were bitten by World Cup fever in my house, watching matches together in the evenings. What a fantastic tournament, with drama in spades. Of course, I'm disappointed England didn't reach the final, but the I thoroughly enjoyed the ding-dong 6-4 third place playoff game against France. 🚴♂️ But, imho, there's an even better sporting spectacle happening in France at the moment:...
Brought to you by: Hi Reader, Welcome (back) to the Google Sheets Tips newsletter, issue #392, your Monday morning espresso, in spreadsheet form! Greetings from the East Coast of the US, where we've been under an Extreme Heat Warning for the past few days, with temperatures at a sweltering 100°F (feels like 114°F with humidity 🥵.) This follows on from the heat wave in the UK a week ago (where I was visiting family) and another in Germany the week before that (where my wife and I traveled for...