Two queries have mentioned in "Queries" sheet of the attached file. Kindly provide solutions
In general it could be done by Power Query, see PQ sheet in attached
Power Query is built in into 2016. For earlier versions you may download as add-in from here https://www.microsoft.com/en-us/download/details.aspx?id=39379&CorrelationId=67016d64-9b83-49d3-b538...
As for the introduction - it's a lot of resources, just google "power query..". You may start from https://support.office.com/en-us/article/power-query-overview-and-learning-ed614c81-4b00-4291-bd3a-5...