Hello,
I'm doing the data collection of a specific property. Basically i have a cleaned table (table 1) with all data from a database and i have another separate table with also data from literature (table 2). I'd like to add information from table 2 to table 1 even if there are duplicates.
For example in table1 i have" methane " and i'd like to add the information of methane from table 2 starting from the last data of methane of table 1 (it means from row 10)
table 1.PNG
if the data from table 2 is not present in table 1 i'd like to add the data at the end of the datasheet. It is the case of isobutane which is not present in table 1 but i'd like to add it at the end of table 1
table 2.PNG
So and ilustration of what i'd like to have at the end it would be this ( the data of isobutane from table 2 it would be at the end of table 1) :
table 3 finale.PNG
I hope it was clear enough thank you!
Bookmarks