A Power Query transformation that converts wide data with multiple columns into a long, normalized format with key-value pairs.
Experimente com IAUnpivoting transforms data by taking column headers and moving them into a single attribute column, while the corresponding cell values are moved into a single value column. This process is essential for preparing data for analysis, as it converts cross-tabulated reports into a database-friendly format.
If you have columns for 'January', 'February', and 'March', unpivoting them creates one 'Month' column and one 'Sales' column, resulting in a vertical list of data.
Use Unpivot when your data is in a wide format with repeating categories as column headers, making it difficult to perform calculations or create Pivot Tables.