Quit the data-search struggle by organizing your raw data into a Microsoft Excel spreadsheet. Rather than manually scrolling through a list of disorganized records, use Excel's built-in tools to ...

The same feature allows you to convert horizontal row data sheets into vertical column style sheets. The feature works with all recent versions of Microsoft Excel, including Office 365.

When you do, Excel launches the Convert Text To Columns Wizard. Make sure the Delimited radio button is selected, and click Next. Since the delimiter in this raw data is simply the space between ...