Forum Discussion
Solved
Issues with Text to Column
Hello All, The issue I am having is figuring out which setting I need to change in order to prevent the following scenario from happening. Please keep in mind this report has approx 18K rows and ...
HansVogelaar Actually upon further testing of the file it appears that the text to column deletes the header when selecting that box and shifts the data into the incorrect columns, such as cash now reporting in the date field and dates reporting in the unique identifier column
In that case, the data file now has a different structure.
Insert enough columns to the right of the data column.
Then untick the 'Treat consecutive delimiters as one' check box in the Text to Columns wizard.