Forums

The forums ran from 2008-2020 and are now closed and viewable here as an archive.

Home Forums Other Combining 2 CSV/Excel files into 1 – Hoping there is a method that will work.

  • This topic is empty.
Viewing 1 post (of 1 total)
  • Author
    Posts
  • #30551
    burtflaxton
    Participant

    I have 2 csv files that I need to combine into 1. Ideally I would like to know how to achieve this in Excel/Libre Office, but if it requires another type of database management software that will do. Any solution is better than what I have now.

    CSV # 1 has 5 columns
    YMMID | YEAR | MAKE | MODEL |

    CSV # 2 has 2 columns
    YMMID | PART# |

    In CSV # 1 the YMMID is the “ID” of the Year, Make, Model. Each different combination of Year, Make, Model has a different YMMID.

    In CSV # 2 the Part #’s Year, Make, and Model is identified by the YMMID.
    What I need is to be able to eliminate the YMMID and create a list with the following columns.

    CSV # 3
    Part # | Year | Make | Model |

Viewing 1 post (of 1 total)
  • The forum ‘Other’ is closed to new topics and replies.