Hi Catalin, I will have to do that almost every day. It is still taking too much time and I will stop working with power query. Shall we st...
Hi Catalin, I have attached word document copying your recommendation and what I tried to replicate with your instructions. Please have a look a...
Thanks, Catalin. it is still extremely slow. Please see my screen shot. Under Other Queries[3], Data is my original table which I cleaned t...
Hi Catalin, I am not so sure what you mean. I have the data table name "Data" and I cleaned them to get about 16000 lines only. Then I used t...
Hi Catalin, I am now completed the step for function - FilteredID. Thank you so much. Phew! I now have to take so much time putting an addi...
Thank you so much Catalin. I am now able to do FilteredID function. However I am stuck with an error message. Please see my work sheet and pl...
Thanks, Mynda and Sunny. Regards, Aye
Thank you so much, Sunny, It works perfect on my data. I would like to learn VBA. Is there any course you recommend? Regards, Aye
Hi Catalin, I am struggling with my live data. to get to the stage I have done following steps in Power Query. let Source = Folder.Files("F:User...
Opp! sorry, Please see attached, Sunny. Thank you. Regards, Aye
Thank you so much, Catalin I am still trying to understand the function you used. (ID)=> let Source = Excel.CurrentWorkbook(){[Name="Table1"]...
Thank you so much, Catalin. I now get the list where more than one category for the same ID. As I need to figure out reducing over the period, c...
Hi Catalin, I am so sorry that I sort of open multiple topics for this as I was a bit of desperate finding the solution and different scenarios cam...