Kim has a distribution list in Outlook with 130+ names. She wants those names in Excel. When she copies and pastes, everything ends up in a single cell.
In this episode, a simple set of steps to split the distribution list into rows and then columns for Name and E-Mail address.
These steps won’t (yet) work on a Mac. You are using the Get & Transform tools (also known as Power Query) on the Windows version of Excel.