Data Shifted to next column

[enkenmendoza]

Hi I am currently facing data shifting issue. There is one column that I just want to move it according to its right position. I just want to fix it

From this:

F1	DocNo	Docdate	Postdate	Code	Name	Type	Amount	SG	Asg	Text
1008143159	10/19/2020	10/20/2020	500010	Utilization Expense	K1	600		166448501-PF1	DR-9307-10-19-20
	1008143161	10/19/2020	10/20/2020	500010	Utilization Expense	K1	600		166531346-PF1	DR-9307-10-19-20

To this:

F1	DocNo	Docdate	Postdate	Code	Name	Type	Amount	SG	Asg	Text
	1008143159	10/19/2020	10/20/2020	500010	Utilization Expense	K1	600		166448501-PF1	DR-9307-10-19-20
	1008143161	10/19/2020	10/20/2020	500010	Utilization Expense	K1	600		166531346-PF1	DR-9307-10-19-20

Could you help me with this one pls?

[AngelosPachis]

Hi @enkenmendoza ,

The slightly painful way to do that is through a union tool. You can split out groups of records that have been moved by one column to the right/left and then bring them together with a union tool.

The union tool will allow you to manually configure which fields are stacked together.

Hope that helps,

Angelos

[danilang]

Hi @enkenmendoza 

How do you know which rows need to be adjusted? Is it always the ones that have a value in F1?

Dan