Solved

Access - Split Column Add Rows

Posted on 2011-02-16
5
275 Views
Last Modified: 2012-08-13
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
0
Comment
Question by:tahirih
5 Comments
 
LVL 12

Expert Comment

by:sstampf
ID: 34913541
I can do this by creating an excel macro. Will that be ok with you?
0
 

Author Comment

by:tahirih
ID: 34915942
At this time - let me work on other options before you take your time to create a macro. Please wait.

Thanks
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 34918779
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
 
LVL 40

Accepted Solution

by:
als315 earned 500 total points
ID: 34926742
Look this example
DB26827637.mdb
0
 

Author Closing Comment

by:tahirih
ID: 34944095
Thank you.
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

838 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question