Hopefully this is in the right forum.
I have over 50 different sets of data in CSV format containing clients information.
I want to create a MASTER FILE with all this data in one place.
Problem I have is two fold :-
Not all files are in the same order of Columns , eg one might be
TITLE, NAME, ADD1 ,POSTCODE
and the next might be in
POSTCODE, NAME, NUMBER ,ADD1 etc
Is there any way of importing the files into a master file and being able to MAP these fields so that they are imported automatically into the correct cells in the MASTER FILE so I finish up with one nice clean file with ALL POSTCODES in one column etc.
Sorry, if its not really clear what I need. Thank you.
I have over 50 different sets of data in CSV format containing clients information.
I want to create a MASTER FILE with all this data in one place.
Problem I have is two fold :-
Not all files are in the same order of Columns , eg one might be
TITLE, NAME, ADD1 ,POSTCODE
and the next might be in
POSTCODE, NAME, NUMBER ,ADD1 etc
Is there any way of importing the files into a master file and being able to MAP these fields so that they are imported automatically into the correct cells in the MASTER FILE so I finish up with one nice clean file with ALL POSTCODES in one column etc.
Sorry, if its not really clear what I need. Thank you.
