Moving data to another cell

PixelJuggler2981

Hi!

I would like to know the possible ways to move the highlighted part to a new column name "Account No" beside the column name "Account". The account no (0102-XXX-XX) has to be right beside (on the same row as) the account type (CASH-UB-XXXXXXXXX).

Appreciate any help!  

Thanks!

Capture.PNG

DanM

@PixelJuggler2981 

Check out the Transpose and Cross Tab tools. They will be able to turn your data to allow you to remove the Account No from the data and then use tools like the Sample Tool and either Join or Union tools to put the Account No back next to Account.