AUTOMATOR FOR EXCEL DATA ANALYSIS
Please, help!
So, I have this huge Excel document (Columns A-L and Rows 2-32,400) that I need to analyze.
Columns B2:D32,400 carry the identity of the individual.
Columns E2:L:32,400 carry the data to be analyzed.
After the identity and all corresponding data for each individual has been grouped together, I need an extra row to be added before each cluster of individuals in order to show the numeric average for each column for that individual.
Exemple:
| Timestamp | Period | Presenters First Name --- ONLY | Presenter Last Name --Only | Project Completed ON TIME [Yes] | Pre-Presentation [How real it looks (authentic)] | Pre-Presentation [Effort, Care, & time visible] | How did they present and answered the statements? [How did the ancient culture make this project?] | How did they present and answered the statements? [What did the ancient culture use this object for?] | How did they present and answered the statements? [What was the significance of this object?] | How did they present and answered the statements? [How did you make the project?] | How did they present and answered the statements? [What steps did you take to make sure the object looked authentic and accurate?] |
| AVERAGE | 10 | 8 | 9 | 7 | 8 | 8 | 9 | 8 | |||
| 5/3/2016 8:29:42 | 1st | Spider | Man | 10 | 10 | 10 | 8 | 10 | 10 | 10 | 6 |
| 5/3/2016 8:31:55 | 1st | Spider | Man | 10 | 10 | 8 | 8 | 8 | 8 | 10 | 8 |
| 5/3/2016 8:31:48 | 1st | Spider | Man | 10 | 10 | 10 | 8 | 10 | 10 | 10 | |
| 5/3/2016 8:30:06 | 1st | Spider | Man | 10 | 8 | 8 | 6 | 8 | 6 | 10 | 10 |
| 5/3/2016 8:28:33 | 1st | Spider | Man | 10 | 10 | 10 | 8 | 8 | 8 | 8 | 8 |
| 5/3/2016 8:29:31 | 1st | Spider | Man | 10 | 8 | 10 | 8 | 8 | 8 | 8 | 8 |
| 5/3/2016 8:28:24 | 1st | Spider | Man | 10 | 10 | 10 | 10 | 8 | 6 | 10 | 10 |
| 5/3/2016 8:32:03 | 1st | Spider | Man | 10 | 8 | 6 | 8 | 6 | 8 | 10 | 6 |
| 5/3/2016 8:29:32 | 1st | Spider | Man | 10 | 4 | 6 | 4 | 4 | 6 | 10 | 10 |
| 5/3/2016 8:30:03 | 1st | Spider | Man | 10 | 8 | 10 | 8 | 6 | 6 | 10 | 6 |
| 5/3/2016 8:28:50 | 1st | Spider | Man | 10 | 6 | 10 | 4 | 6 | 8 | 8 | 8 |
| 5/3/2016 8:30:11 | 1st | Spider | Man | 10 | 10 | 10 | 8 | 10 | 8 | 10 | 8 |
| 5/3/2016 8:29:27 | 1st | Spider | Man | 10 | 10 | 10 | 6 | 6 | 6 | 10 | 8 |
| 5/3/2016 8:29:19 | 1st | Spider | Man | 10 | 8 | 8 | 8 | 8 | 8 | 8 | 10 |
| 5/3/2016 8:28:48 | 1st | Spider | Man | 10 | 6 | 8 | 8 | 6 | 8 | 10 | 8 |
| 5/3/2016 8:28:38 | 1st | Spider | Man | 10 | 6 | 4 | 4 | 6 | 6 | 4 | 6 |
| 5/3/2016 8:28:28 | 1st | Spider | Man | 10 | 10 | 8 | 10 | 10 | 8 | 8 | 8 |
| 5/3/2016 8:28:17 | 1st | Spider | Man | 10 | 8 | 10 | 6 | 8 | 8 | 8 | 8 |
| 5/3/2016 8:27:47 | 1st | Spider | Man | 10 | 6 | 8 | 8 | 10 | 10 | 8 | 8 |
| 5/3/2016 13:15:55 | 1st | Spider | Man | 10 | 10 | 10 | 4 | 10 | 8 | 10 | 10 |
| 5/3/2016 8:28:36 | 1st | Spider | Man | 10 | 8 | 10 | 10 | 10 | 10 | 10 | 10 |
Is it possible to get automator to do that?
Thanks,
MP
MacBook Air, OS X El Capitan (10.11.1)