I am doing a data load.
The data was exported from the old system with data for each part in a single row
The data for the new system needs to be in multiple rows for a single part to be imported. How can I automate this process in excel?
For example (this is a simple example the real one has 18 rows per part for the new system)
Old data:
PartNameA PartNumberA PartDescriptionA
PartNameB PartNumberB PartDescriptionB
PartNameC PartNumberC PartDescriptionC
I need the new data to show:
PartNameA
PartNumberA
PartDescriptonA
PartNameB
PartNumberB
PartDescriptionB
PartNameC
PartNumberC
PartDescriptionC
Thanks!
Bookmarks