Power Query is a powerful data transformation engine built into Microsoft Excel and Power BI. It allows users to connect to various data sources, clean and reshape data, and prepare it for analysis—all without writing complex code. One of the most essential areas in Power Query is the Transform tab, specifically the Table section, which provides tools to manipulate entire tables and control their structure