Hi Riny Wow, so is possible to apply Comparer.OrdinalIgnoreCase to List, and what does the 1 stand for ? thank you so much Sir
Hi Jojemar The quick way is to Append table 2 to table 1, then Group by Product and Component, two aggregations Actual and Standards Just Min or ...
Hi Riny, will test it out, looks like the Base_2 got to add in remove duplicates to make it unique thank you so much !
HI Velouria List.Zip is cool and it works even with ID. Thanks Hi Riny : - Thank you for your solution !
Hi Riny, Thank you for your time, how to distribute the ID correctly to each Name+Department ? Sorry I forgotten about the unique identifier ...
Hi Riny, thanks for your quick response, my sample is only one record (original source got few hundred), and how to handle multiple records usin...
Hi, Can attach your PQ here for us to take a look on your error.
Hi, it is the same as desktop Excel =VLOOKUP(A2,Sheet2!A1:C5,3,FALSE) or you can upload a sample worksheet and tell us what you want to ...
Hi, easier to do it in Power Query Worksheet one is your source which consist only raw columns, bring into Power Query, the following are the ...
Another way (may be longer with some tricks) first insert the Month name for each date, then group by Month name, max of Date and the entire table,...
Hi Mynda, Thanks for pointing it out and notice that got to use square bracket for Date A and Date A in QTR, "Date A" and "Date A in QTR" will no...