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
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
What will be the best method to push the row to the right
Perhaps not the best solution, but it does work for the sample you provide. See attached,
@PhilipMannering unfortunately we cant use Python in this project
Before I do it in R, is there something I should know?
Do you have this as a csv input?
If yes could you put an exemple of the data in csv? This issue is easier to connect on the csv level.
@PhilipMannering we cant use any other language, we have to use alteryx tools only
@Emil_Kos added CSV