You can move fields to a different location using a rules file. For example, you can specify the first field in the data source to be the third field during the data load or dimension build.
In some instances, moved fields may appear to merge. If you move a field that contains empty cells, and the moved field becomes the last field in the record, as shown below, the field may merge with the field to its left.
1<tab>2<tab>3 1<tab>2<tab>(null)
To prevent merging, replace the empty cell with a delimiter.