3 ms·

Look up Power Query, which has been part of Excel for a while.

• andylynch 6y ago
  Yea, power query is fantastic! Only caveat is you can’t (yet) use the editor on Mac, though it’s coming.