Text to Column Issue

If you encounter an issue where all the data appears in a single column after exporting reports from the Console, please follow the steps below to resolve it.

1. Open the exported file, then click on the header of column A to select the column containing all the data.
2. From the top ribbon, go to the "Data" tab. 
3. Click on "Text to Columns" — the "Convert Text to Columns Wizard" window will appear.
4. Under "Original data type", select "Delimited" (characters such as commas or tabs separate each field). Click "Next".

          5. Under the "Column data format" section, select "General" — this option converts numeric values to numbers, date values to dates, and all remaining values to text.

          6. Click "Finish".

           7. Under the "Delimiters" section, check the "Comma" option only and make sure all other options are unchecked, then confirm in the "Data preview" section that the data is now split correctly. 

           8. Click "Next".