Now that the data from the workbooks has been combined and transformed, it's time to see how it looks in a regular Excel worksheet. In the Home tab on the Power Query Editor window, click the top half ...

There are other free text expanders out there, but let's be honest. They aren't actually free. The aptly-named TextExpander uses a subscription model, but other tools like aText and Phrase Text ask ...