Extracting data from a matrix

Concept like this:

1. Install Power Query Add-In
   
   
2. Load Your Matrix into Power Query
• Select your matrix and go to Power Query > From Table
• Make sure your matrix has headers (e.g. years) and row labels (e.g. depts)
3. Unpivot the Data
   • Select the column containing depths
   • Right-click and choose Unpivot Other Columns
   • Dept
   • Attribute (year)
   • Value
• In Power Query:
• This will convert your matrix into a table with:
4. Rename Columns
• Rename “Attribute” to “Year”
• Rename “Value” to “Measurement” or whatever fits your context
5. Filter Out Empty Values
• Use the filter dropdown on the “Value” column to remove null or empty cells
6. Load the Clean Table Back to Excel
• Click Close & Load to insert the cleaned table into a new sheet