For a very basic example, lets say I want 3 columns FirstName|LastName|Age And client files look like ClientA: First|Last|Age ClientB: Age|FirstName|Last C

For a very basic example, lets say I want 3 columns FirstName|LastName|Age And client files look like ClientA: First|Last|Age ClientB: Age|FirstName|Last CientC: FullName|Age ClientD: DateOfBirth|First|Last So they all have the required info, but some intervention is required. Column matching/renaming Column order Splitting full name to first/last Converting DateOfBirth to Age