Hi, In the attached Excel workbook, once these are imported into Acces, please offer how I may transform 'Original' table into 'New.'
Please note the following main changes:
1. Values in Column D are separated into their own individual rows
2. The value in Column I then needs to be filled into each of the new individual rows.
This is only a sample. Column D may have varying values, with up to 100's of values in column I that need to be populated into the newly created rows from Olumn D.