I apologize, that does not really answer my questions, and therefore I still do not know what you are looking for. To me, it looks like you have just copied the cells from sheet 2 where the ticket is ALZ.1 onto the third sheet. Ideally, I want to know how to merge the data and what you want it to look like, which tickers to use between the two sheets, and how the two sheets should be integrated into one.

If you were just going to copy the data, I would just insert columns so everything matches up and then copy, paste and sort. I am assuming this is not what you are looking for, though.