I cannot figure out how to solve this and I think it may be because I am making this more complicated than it needs to be… But I need some help.
I am trying to combine two data tables. I have one spreadsheet that I am reading and replacing some values by getting those from another spreadsheet. I have both in Excel sheets read to data tables, but cannot figure out how to replace the values in each Data Row with the values I’m hoping for.
For example, lets say one data table is called dtColors and the other is dtAnimals. I am hoping to replace the first and third values of each row in dtAnimals with values from each row of dtColors.
dtColors could be: [row 1]: Red, Orange, Yellow, Green
[row 2]: Blue, Indigo, Violet, Black
dtAnimals could be: [row 1]: Lion, Tiger, Bear, Frog
[row 2]: Cow, Horse, Goat, Pig
What I am hoping to get would look like this: [row 1] Red, Tiger, Yellow, Frog
[row 2] Blue, Horse, Violet, Pig
This is a much simpler version of what I am trying to do but I hope that providing an example would be helpful to someone that might be able to help me…
Thanks for your time.