Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Merge sheet rows and keeping columns

Hi,

 

I want to merge rows from two data sheets from the same Excel file. But when I "Merge reguests as new" and expand the new colum choosing all colum names from the other sheet, it says "null". 

 

I want all the data rows to be under the same four colums, because they have the same names anyway.

 

Can anyone help?

 

Best regards Jonas 

2 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion

    Hi Anonymous

     

    Perhaps you are using Merge Query

     

    You ought to use APPEND QUERIES

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      That was it! Thanks :)