In Sheet3 of the attached there's an additional table (green) based on the data in Sheet1 converted to a proper Excel table. All you need to do is update the table on Sheet1 ensuring all the data is in included in that table, then go to Sheet3, right-click the table and chose Refresh to update it. No formulas, no VBA.

Attached Files

msofficeforums47554TextjoinPivotsAndPQ.xlsx (49.9 KB, 7 views)

Hi thanks for help!!

I hope you have used the power query.

May i know what function/query you have used to get Eng Hrs?

So that i can append my data the same

thanks again!!