How to pad data with existing data

[Charlie_xiao]

Hi,  I have two tables, table 1 and table 2. The table 2 missed some data (scale, force) for low speed values. But table 1 has the data for low speed values. So I want to pad the second table by using the data from table 1.  The padded table 2 should looks like table 3. Note that I am only using 'Scale' and 'Force' from table 1 to pad table 2, the index in table 3 should be the same as table 2. And that is why table 3 has all 'Index' equal to 4.

Table 1

Table 2

table 3

Thanks

Charles

[MichaelSu · Accepted solution]

Hi @Charlie_xiao ,

Please see attached solution. This is how I thought to accomplish what you're looking to do, I am sure there are multiple ways. Let me know if you have any questions.

Thanks,

Mike

[Charlie_xiao]

Thank you so much!!!! It is a very good solution!

Charles