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
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
Is this what you wish your solution to look like?
Excel 2016 (Windows) 32 bit
P Q R S 5Date Company Dividend Uniqe code 6 1/1/2020Company A 10 999 7 1/1/2019Company C 9 997 8 1/1/2021Company B 11 998 9 1/1/2022Company D 12 996
Sheet: Sheet1
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Hi Alansidman,
Yes! Thats exactly right.
Would you mind sharing your knowledge?
Kind Regards
Magnus
this is the approach I would take to do this:
https://www.youtube.com/watch?v=HcfKOusOJhA
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?
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.
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.
Hi Flyboy,
Wauw, thats a nice one! Thanks for the help!
Kind Regards
Magnus
Glad to help. Thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks