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
tahirihAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
als315Connect With a Mentor Commented:
Look this example
DB26827637.mdb
0
 
sstampfCommented:
I can do this by creating an excel macro. Will that be ok with you?
0
 
tahirihAuthor Commented:
At this time - let me work on other options before you take your time to create a macro. Please wait.

Thanks
0
 
Jeffrey CoachmanMIS LiasonCommented:
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...
0
 
tahirihAuthor Commented:
Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.