Apr 13 2022 07:22 AM
I have been given a large data set (about 6000 rows) but it formatted incorrectly. The 3 data types have been inserted into the same column but separated by an indent (see photo below). to analyse the data I need to have each set in separate columns is there a quick way to do this? many thanks
Apr 13 2022 07:31 AM
SolutionSelect the column.
On the Data tab of the ribbon, click Text to Columns.
Select Delimited, then click Next >.
Select Tab as delimiter, then click Finish.
Apr 13 2022 07:31 AM
SolutionSelect the column.
On the Data tab of the ribbon, click Text to Columns.
Select Delimited, then click Next >.
Select Tab as delimiter, then click Finish.