Let's say you've got all the data you need––it just isn't in the right place.
"Flash Fill" is your friend.
Quickly extract pieces of text from one cell and move them to another OR combine text from multiple cells into a single place.

12 Google Sheets formulas guaranteed to \U0001f4c8 your productivity today:
— Blake Burge \U0001f4a1 (@blakeaburge) January 21, 2022
Learning is a skill.
— Sahil Bloom (@SahilBloom) August 28, 2021
Here's a tactical approach to learning anything:
Early career years are painful.
— Romeen Sheth (@RomeenSheth) July 27, 2021
You feel like an idiot 98% of the time - lost, confused and insecure.
I wish I had a cheat sheet of principles for my first job.
So I put one together.
Here are 20 things about building a career I wish I knew sooner:
It's been over a decade since I kicked off my career.
— Ndamukong Suh (@NdamukongSuh) August 27, 2021
I've worked with, invested in, and mentored some of the most elite people on the planet.
And you know what I've noticed? \U0001f440
From Tom Brady to Warren Buffet, they all have five things in common.
If you're curious \U0001f9f5
We ALL have a problem.
— Blake Burge \U0001f4a1 (@blakeaburge) July 10, 2021
We overestimate what can be done in a day, yet underestimate what can be accomplished in a week, month, or year.
THREAD: 10 Steps to get from where you are to where you want to be. pic.twitter.com/uRJuCfldII
PSYCHOLOGY MEGATHREAD:
— Dr. Emily Anhalt (@dremilyanhalt) February 11, 2020
40 of my favorite psychological concepts, introduced as thoroughly as I could manage in 280 characters or less.
These are core human behaviors that play out in all relationships, & are explored through therapy.
Enjoy, ask questions, & add your own!
Things I know at 35,
— Amanda Goetz (@AmandaMGoetz) July 27, 2021
I wish I had known at 25.
\U0001f9f5/
Emails like this where you need to "prove" your rates, while simultaneously being told you are "overpriced" are never worth the response (unless you're responding with a clapback). pic.twitter.com/nmVmQJHVI5
— Brittany | Influencer Marketing + Social Media (@MissBeeBright) August 10, 2021
I was burned out in finance, working on someone else's schedule, tired of having my time tied to $.
— Codie Sanchez \U0001f4a5 (@Codie_Sanchez) April 9, 2021
So I started investing in cash-flowing biz's.
Not sexy startups, but boring businesses.
One of my fav small deals netted $67k a year, $100k at close... w/ quarters
A thread: pic.twitter.com/Mv0diWoPeB