How to move the column data to the right

[Sshasnk]

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

[PhilipMannering]

Perhaps not the best solution, but it does work for the sample you provide. See attached,

[Sshasnk]

@PhilipMannering  unfortunately we cant use Python in this project

[PhilipMannering]

Before I do it in R, is there something I should know?

[Emil_Kos]

Hi,

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.

[Sshasnk]

@PhilipMannering we cant use any other language, we have to use alteryx tools only

[Sshasnk]

@Emil_Kos  added CSV