+ Reply to Thread
Results 1 to 1 of 1

how to add information from a table to another

  1. #1
    Registered User
    Join Date
    03-04-2021
    Location
    france
    MS-Off Ver
    2010
    Posts
    3

    how to add information from a table to another

    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!
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 04-19-2020, 06:16 AM
  2. Auto add rows in a table when information is input in different table
    By Sammydasalmon in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-15-2019, 05:09 AM
  3. [SOLVED] Macro To copy information in a table (keeping format and nested table intact)
    By meabrams in forum Word Programming / VBA / Macros
    Replies: 6
    Last Post: 03-29-2017, 03:20 AM
  4. Replies: 4
    Last Post: 12-31-2016, 04:06 AM
  5. [SOLVED] Copy and paste formula outside pivot table using information from table
    By batjl9 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-01-2014, 07:10 AM
  6. Heat Mapping by row for a table of information (or a pivot table)
    By jacebailes in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-06-2013, 06:22 PM
  7. Replies: 9
    Last Post: 03-29-2012, 06:11 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1