Rearrange data columns

[TiffanyH12]

I have two data sets joined by a common account number. I want to have the same columns from both sets be shown next to each other but using the select tool to drag and drop 50+ columns is very time consuming. Any suggestions?

The columns in both sets have the exact same names.

What I want:

Acc. #	DataSet1Col1	DataSet2Col1	DataSet1Col2	DataSet2Col2
###
###
###
###

If possible I also want to be able to find the differences between data set 1 and 2 and have a new column insert after. So at the very very end should look like below. I need the differences from each criteria so that's 50+ more which would again be very time consuming to do formulas for each one.

Acc.#	DataSet1Col1	DataSet2Col1	Difference	DataSet1Col2	DataSet2Col2	Difference

[Qiu · Accepted solution]

@TiffanyH12 
Prepared something for your.
Please note that you still need to adjust according to your real case.

[TiffanyH12]

Thank you! I was able to apply this to my workflow. Is there a way to put the difference column after the first two columns of data instead of in between without having to use manually rearrange all of them?

[Qiu]

@TiffanyH12 

Thank you for the mark. 

And yes to your question.