Data in wrong column

[MykieJ]

Hi, I am trying to clean and transform this file but how do I move the date to the "date" column and J$ the Currency ID column in the fews instances where this is happening.

 Help anyone... Thanks

[Greg_Deckler]

@MykieJ Try creating new columns like these and then removing the old Date and Currency ID columns:

New Currency ID 
= if [Currency ID] = null then [Date] else [Currency ID]


New Date
= if [Currency ID] = null then [Type] else [Date]