Unpivot a Matrix into a Columnar Table in Excel
ฝัง
- เผยแพร่เมื่อ 25 ส.ค. 2024
- This video shows how to create a matrix table (a table with row and column headers) into a columnar table so that you can create a Pivot Table or perform other range operations to the data. This solution uses Power Query's Unpivot Tool that returns matrix data into columnar data.
great video. concise and clear speaking with good volume. i got exactly what i needed from this. thanks!