Align staggered Information

[calvincarr29]

Problem:

I joined two containers with the Union command and it produced staggered information. 

Need: I need to move the the information that starts on Row 706 for columns Account Number, Description, Account Name and Amounts to Row 1 

 

 

[AndrewDMerrill · Accepted solution]

If you still have access to both data streams, I suggest replacing the Union Tool with a Join Tool (set to Join by position). This should accomplish exactly what you need. The only thing you'd need to do afterward is union all outputs ("L", "J", & "R") to account for the case where row count is different between data sets.

[calvincarr29]

@AndrewDMerrill Thank you so much