minbe-data 님의 블로그

Many Excel reports contain monthly sections such as Jan, Feb, and Mar mixed together in a single worksheet. This type of structure is difficult to analyze because the data is not arranged in a proper table format. In this example, Power Query automatically: - Detects month header rows - Fills month values downward - Cleans supplier data - Unpivots the report structure - Combines month and attrib..

In Excel, monthly purchase data is often stored in a messy report format. For example, month names such as Jan, Feb, and Mar may appear as section headers, while supplier and purchase information are listed underneath. This structure is difficult to analyze directly with Pivot Tables. In this example, Power Query automatically cleans the report by: - Detecting month header rows - Filling month v..