How to get Amnt 1 and Currency1 into Amount and Currency column?

[vinayvnn]

Amount	Currency	Amnt1	Currency1
1	INR
20	INR
23	INR
55	INR
		22	INR
		35	INR
		45	INR

On the above data, I want Amnt1 to be moved to Amount and Currency1 to be moved to Currency. Any leads will be much appreciated.

[MilindG]

@vinayvnn Does this work for you?

[RaphaelSilva]

Here's another way to achieve the same thing MilindG did, just in case it is easier on your actual dataset

[ChrisTX]

Use a Formula tool.  

For field Amount: IF IsEmpty([Amount]) THEN [Amnt1] ELSE [Amount] ENDIF

For field Currency: IF IsEmpty([Currency]) THEN [Currency1] ELSE [Currency] ENDIF

Chris