Merge data from two datatapes

[Magnus415]

Hi all,

I am struggling to merge data from two different data tapes.

Please see attached. Anybody with a clever suggestion on how to do this?

Help1.JPG

Thank you in advance.

Kind Regards
Magnus

[alansidman]

Is this what you wish your solution to look like?

Excel 2016 (Windows) 32 bit

	P	Q	R	S
5	Date	Company	Dividend	Uniqe code
6	1/1/2020	Company A	10	999
7	1/1/2019	Company C	9	997
8	1/1/2021	Company B	11	998
9	1/1/2022	Company D	12	996

Sheet: Sheet1

[Magnus415]

Hi Alansidman,

Yes! Thats exactly right.

Would you mind sharing your knowledge?

Kind Regards
Magnus

[alansidman]

this is the approach I would take to do this:

https://www.youtube.com/watch?v=HcfKOusOJhA

[Magnus415]

Thanks for the link!

But as I am looking to do this in Google Sheets, Im not quite sure this will work.

Do you agree or is Power Query available in Google Sheets as well?

[alansidman]

Power Query is not an option in Google Sheets. Since you did not mention this in your original post, I am moving this to the applicable sub forum.

[Flyboy65]

Hi Magnus415

Put the following formula in cell J6 of your GSheet: =QUERY({P6:S;U6:X7},"Select * where Col1 is not null")

Let me know if this is what you are after.

[Magnus415]

Hi Flyboy,

Wauw, thats a nice one! Thanks for the help!

Kind Regards
Magnus

[Flyboy65]

Glad to help. Thanks for the feedback.