In 2016 Excel the tool has moved to the Data Tab. Power Query was an Add-In tool from Microsoft in 2010 and 2013 Excel and finally built into 2016. They changed the name to "Get & Transform" instead of "Power Query". All the functions are the same. I believe you need/want to learn and use Get & Transform to do your problem.

Watch some YouTube showing this tool.

https://www.youtube.com/watch?v=lDk5dOFe-YE