just do the first two manually and press CTRL+E for the rest to be done with flash fill However, this video is invaluable because it takes care of changes to in the data and dynamically change the required data to extract.
That's a very good suggestion indeed. However, I have found flash fill to be a bit unreliable at times, so knowing how to solve the problem using formulas is definitely a bonus.
just do the first two manually and press CTRL+E for the rest to be done with flash fill
However, this video is invaluable because it takes care of changes to in the data and dynamically change the required data to extract.
That's a very good suggestion indeed. However, I have found flash fill to be a bit unreliable at times, so knowing how to solve the problem using formulas is definitely a bonus.