Q:

Correct sorting after text to columns in EXCEL

I have some data in which one column represents the Days of Operations, as below:
-------
Days
-------
15
7
1234567

etc.
I want to "break" the column (via text to columns option in the Data tab of Excel) and create the following columns:
--------------------
D1|D2|D3|D4|D5|D6|D7
--------------------
 1|  |  |  | 5|  |  |
  |  |  |  |  |  | 7|
 1| 2| 3| 4| 5| 6| 7|           

However, the data is being messed up and I get different days in different columns... How I can overpass this? Is there a way to assign the values accordingly?

A:

I want to "break" the column (via text to columns option in the Data tab of Excel) 

As per your question, you want to do this with Text-to-Columns. Well, that's a no go. Text-to-columns works either on a character delimiter or a fixed width. Your data has neither. You apparently want to distribute the data based on its values. That cannot be done with Text-to-Columns.
You will need a code or a formula solution for that. If you import your source data into a spreadsheet, with all the imported data sitting in column A, you can use a formula like this:
=IF(ISERROR(FIND(COLUMN(A1),$A4)),"",COLUMN(A1))

If the data as posted above starts in A1, then the formula will be in cell B4 and can be copied across and down.

You can hide column A do display just the results of the formula.

