Timeline for Designing a mass attendance system with Excel and PowerQuery
Current License: CC BY-SA 4.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 29, 2020 at 16:44 | comment | added | FlexYourData | Since you have text values, then a pivot table won't work for that table. But you can easily set up a powerquery to reformat it into that particular summary report. Please see my edit. | |
| Jun 29, 2020 at 16:44 | history | edited | FlexYourData | CC BY-SA 4.0 |
added a way to get back to OP's reporting format
|
| Jun 29, 2020 at 15:07 | vote | accept | Pan Ziyue | ||
| Jun 29, 2020 at 15:07 | comment | added | Pan Ziyue | Thanks, this solution is exactly what I need! Quick question: should I require an overview of all attendance table just like the 3rd table I described in my original post, do I need to set up some sort of a pivot table? | |
| Jun 29, 2020 at 13:50 | history | answered | FlexYourData | CC BY-SA 4.0 |