Results 1 to 5 of 5

Thread: merging 2 databases together

  1. #1

    merging 2 databases together



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I want to merge 2 excel databases based on the first column (called ''ticker''). To make it complicated, some tickers have a slightly different format in the 2 files (for example Alza Corp is called "AZA" in the first sheet and "AZA.1" in the second sheet, these have to be merged). To make it even more complicated, the sheets have a different amount of rows and some companies that are in one sheet are not in the other and the other way around. I have pasted a small part of the total database in the attachment. The columns 'firm_id' and 'numblks' from sheet 1 have to end up next to the column 'Gind', as already done manually for ALZA CORP.

    Who can help me?? I have already spent almost 2 days solving this, but become more and more desperate every minute..

  2. #2
    I want to merge 2 excel databases based on the first column (called ''ticker''). To make it complicated, some tickers have a slightly different format in the 2 files (for example Alza Corp is called "AZA" in the first sheet and "AZA.1" in the second sheet, these have to be merged). To make it even more complicated, the sheets have a different amount of rows and some companies that are in one sheet are not in the other and the other way around. I have pasted a small part of the total database in the attachment. The columns 'firm_id' and 'numblks' from sheet 1 have to end up next to the column 'Gind', as already done manually for ALZA CORP.

    Who can help me?? I have already spent almost 2 days solving this, but become more desperate every minute..

  3. #3
    I want to merge 2 excel databases based on the first column (called ''ticker''). To make it complicated, some tickers have a slightly different format in the 2 files (for example Alza Corp is called "AZA" in the first sheet and "AZA.1" in the second sheet, these have to be merged). To make it even more complicated, the sheets have a different amount of rows and some companies that are in one sheet are not in the other and the other way around. I have pasted a small part of the total database in the attachment. The columns 'firm_id' and 'numblks' from sheet 1 have to end up next to the column 'Gind', as already done manually for ALZA CORP.

    Who can help me?? I have already spent almost 2 days solving this, but become more andmore desperate every minute..

  4. #4
    I want to merge 2 excel databases based on the first column (called ''ticker''). To make it complicated, some tickers have a slightly different format in the 2 files (for example Alza Corp is called "AZA" in the first sheet and "AZA.1" in the second sheet, these have to be merged). To make it even more complicated, the sheets have a different amount of rows and some companies that are in one sheet are not in the other and the other way around. I have pasted a small part of the total database in the attachment. The columns 'firm_id' and 'numblks' from sheet 1 have to end up next to the column 'Gind', as already done manually for ALZA CORP.

    Who can help me?? I have already spent almost 2 days solving this, but become more andmoer desperate every minute..

  5. #5
    I wantto merge 2 excel databases based on the first column (called ''ticker''). To make it complicated, some tickers have a slightly different format in the 2 files (for example Alza Corp is called "AZA" in the first sheet and "AZA.1" in the second sheet, these have to be merged). To make it even more complicated, the sheets have a different amount of rows and some companies that are in one sheet are not in the other and the other way around. I have pasted a small part of the total database in the attachment. The columns 'firm_id' and 'numblks' from sheet 1 have to end up next to the column 'Gind', as already done manually for ALZA CORP.

    Who can help me?? I have already spent almost 2 days solving this, but become more desperate every minute..

Posting Permissions

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