Simplify your data transformation by skipping complex parsing expressions and instead using Flash Fill and Power Query in Microsoft Excel.

Source data won't always come in the form you need in Excel. When that happens, consider using Flash Fill to save time and aggravation.

How to use Excel’s Flash Fill feature, including a keyboard shortcut for both Windows and Excel for Mac.