Hi I have a dataset but it is is not align properly because of missing data, now I have to move those columns to the right
Example:
| Id | name | place | quantity | price | fruit | row number |
| 456214 | Alex | tokyo | 5.00 | 15.23 | apple | 1 |
| 456214 | Raj | 10.00 | 100.00 | apple | | 2 |
| 456214 | Tim | new york | 10.00 | 10.00 | banana | 3 |
| 456214 | | | 25.00 | 125.23 | banana | 4 |
| 145267EX | Nick | UK | 5.00 | 20.00 | apple | 5 |
| 145267EX | Luffy | 5.00 | 60.00 | apple | | 6 |
| 145267EX | | | 10.00 | 80.00 | banana | 7 |
| 54123 | Leo | LA | 5.00 | 10.00 | apple | 8 |
| 54123 | | | 5.00 | 10.00 | apple | 9 |
Condition:
1. If you will see row number 2 and 6 the place is missing so to align it correctly I have to move all the columns one to the right
2. If you will look at row number 4 and 9 the alignment is correct So we don't have to do anything
Output:
| Id | name | place | quantity | price | fruit | row number |
| 456214 | Alex | tokyo | 5.00 | 15.23 | apple | 1 |
| 456214 | Raj | | 10.00 | 100.00 | apple | 2 |
| 456214 | Tim | new york | 10.00 | 10.00 | banana | 3 |
| 456214 | | | 25.00 | 125.23 | banana | 4 |
| 145267EX | Nick | UK | 5.00 | 20.00 | apple | 5 |
| 145267EX | Luffy | | 5.00 | 60.00 | apple | 6 |
| 145267EX | | | 10.00 | 80.00 | banana | 7 |
| 54123 | Leo | LA | 5.00 | 10.00 | apple | 8 |
| 54123 | | | 5.00 | 10.00 | apple | 9 |
What will be the best method to push the row to the right
