Hi
I used microsoft query to pull data but unfornatunately the data is in multiply tables so I now want to join the table in order for the data to make sense.
Please see the attached excel workbook.
Thanks for your help in advance
Hi
I used microsoft query to pull data but unfornatunately the data is in multiply tables so I now want to join the table in order for the data to make sense.
Please see the attached excel workbook.
Thanks for your help in advance
Hi Krisuk,
welcome to the forum.
In sheet "aim to achieve this", how you will get values in column G:M.
I got that column C:F, you can get from sheet2
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
Hi DILIPandey,
G:M was picked from E:J in sheet 1.
Hope this helps you to understand it better.
Thanks
krisuk
Hi Krisuk,
Is there any common field (column) between sheet 1 and sheet 2 as this may help in getting information from both the sheets ?
Also, can you manually put in two rows of data basis these two sheets as a sample ? Thanks.
Regards,
DILIPandey
<click on below * if this helps>
I found "DocumentNo" field in sheet2 and I am thinking if this field is there is sheet 1 as well, then we can easily extract complete row. Thanks.
Regards,
DILIPandey
<click on below * if this helps>
The common field is POPOrderReturnID.
sheet1's K2:K5 has same ID.. so which row you need here ? Thanks.
Regards,
DILIPandey
<click on below * if this helps>
yes K2:K5 has the same ID and the line Total Value for them adds up to 492 see F2:F5 in sheet 1 and this is shown in sheet 2 document no 0000010122 in C2 total gross value of P2 sheet 2.
I need all the rows
Okay.. so I manually updated all rows information from sheet1. Now how you would fill the grey cells from sheet2?
Book2.xlsx
Regards,
DILIPandey
<click on below * if this helps>
I am a bit confused.
I don't won't to manually fill the data.I am looking for excel formula which can do that for me.
At least if a formula could be used to pull the document no column unto sheet 1 and link with the right data that will be great.
regards
krisuk
I know this..I don't won't to manually fill the data.I am looking for excel formula which can do that for me.and just wanted to be sure what would be the final result look like after applying formulas and this is what I was expecting from you where you could have said "I have entered results manually and looking for formulas which can output same results" - hope you got the message
Regards,
DILIPandey
<click on below * if this helps>
I have manually completed it now.
Thanks
Please find the completed file.
Thanks
Hi Krisuk,
In sheet "aim to achieve this", paste the data in green cells from sheet 1 and drag down formulas in rest of the columns. thanks.
Book2(2).xlsx
Regards,
DILIPandey
<click on below * if this helps>
Thank you Dilipandey.
I will check this work life data tomorrow and let you know if it works ok.
Thanks you for your wonderful job done.
Regards
Krisuk
Okay... awaiting your reply
Regards,
DILIPandey
<click on below * if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks