Data Migration Mapping

[Noddy69]

Hey peoples

I am working on a new asset system implementation, migrating data from legacy system to the new system. Some of the field names are different in the legacy system to the new system. Is there any kind of mapping functionality in excel where I extract the data from the legacy system and can auto populate the upload template for the new system. The number of columns vary between the legacy system and new system. An example of what I want to do:
Legacy System Field Name New System Field Name
Infrastructure_Number External_ID
Street_Name Location
Pipe_Length Length_of_pipe

Rather than copying and pasting data from one worksheet to another, I want to define the mapping and auto populate upload template for new system
Thanks in advance

GT

 

[Alex Blakenburg]

Typically when you are doing a data migration there is a bit more mapping and transforming of data involved than just mapping the fields.
In terms of the fields, if you set up a mapping table, Power Query would be able to do the mapping of the fields.