tahirih
asked on
Access - Split Column Add Rows
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.
Thank you
Access-Sheet-Transformation.xlsx
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.
Thank you
Access-Sheet-Transformation.xlsx
sstampf
I can do this by creating an excel macro. Will that be ok with you?
ASKER
At this time - let me work on other options before you take your time to create a macro. Please wait.
Thanks
Thanks
I'm with sstampf...
If there is a way to do this in Excel, then go for it.
In Access this will be extremely complex...
If there is a way to do this in Excel, then go for it.
In Access this will be extremely complex...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you.