Forum Discussion
Convert Matrix of Attendance to unique rows
I have a problem that I regularly run into. We get a lot of attendance files that we need to prep for upload to a database. The files have a row for each student and the column headers are dates. ...
You can try Power Query. In the attached file you can add data to the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.
The layout of the tables in the screenshot is for illustration. You can place the green table to the right of the blue table or on another worksheet.
- Wow, you are awesome, exactly what I am looking for!
