To get rid of that time-consuming work, you can check out this step by step guide. How to Split Text to Columns in Excel To split comma-separated text in Excel, follow these steps- ...

Learn how to split one column into multiple columns in Excel. Use Text to Columns and Delimited options and use Delimiters to separate data in Excel.

Called Split View, it works rather smoothly and allows users to have two apps run side by side. Here’s everything one needs to know about the Split View feature: How does Split View work?