Spreadsheet: 825958d1681681650-pulling-data-into-a-new-format-so-i-can-create-a-100-stacked-bar-chart-formula
Sheet: Sheet1

Table 1 in A7:S22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Question | Group | 1 | 2 | 3 | 4 | 5
Group | Score | Q3a | Q3b | Q3c | Q3d | Q3e | Q3f | [NAME] | Q3h | Q3i | Q3j | Q3k | Q3l | Q3m | Q3n | Q3o | [NAME] | [NAME] |  | Q3a | Academic Staff
Academic Staff | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3a | Professional Services Staff
Academic Staff | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3a | Student
Academic Staff | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3b | Academic Staff
Academic Staff | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3b | Professional Services Staff
Academic Staff | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3b | Student
Professional Services Staff | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3c | Academic Staff
Professional Services Staff | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3c | Professional Services Staff
Professional Services Staff | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3c | Student
Professional Services Staff | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3d | Academic Staff
Professional Services Staff | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3d | Professional Services Staff
Student | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3d | Student
Student | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3e | Academic Staff
Student | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3e | Professional Services Staff
Student | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3e | Student
Student | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3f | Academic Staff
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3f | Professional Services Staff
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3f | Student
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Academic Staff
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Professional Services Staff
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Student
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3h | Academic Staff
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3h | Professional Services Staff
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3h | Student
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3i | Academic Staff
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3i | Professional Services Staff
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3i | Student
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3j | Academic Staff
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3j | Professional Services Staff
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3j | Student
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3k | Academic Staff
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3k | Professional Services Staff
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3k | Student
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3l | Academic Staff
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3l | Professional Services Staff
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3l | Student
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3m | Academic Staff
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3m | Professional Services Staff
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3m | Student
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3n | Academic Staff
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3n | Professional Services Staff
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3n | Student
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3o | Academic Staff
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3o | Professional Services Staff
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3o | Student
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Academic Staff
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Professional Services Staff
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Student
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Academic Staff
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Professional Services Staff
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Student
Q3
Academic staff - Colleges
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Not at all effective | Not effective | Neutral | Effective | [NAME]
used different data sheet in formula |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Question | Group | 1 | 2 | 3 | 4 | 5
Group | Score | Q3a | Q3b | Q3c | Q3d | Q3e | Q3f | [NAME] | Q3h | Q3i | Q3j | Q3k | Q3l | Q3m | Q3n | Q3o | [NAME] | [NAME] |  | Q3a | College A
College A | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3a | College B
College A | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3a | College C
College A | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3b | College A
College A | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3b | College B
College A | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3b | College C
College B | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3c | College A
College B | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3c | College B
College B | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3c | College C
College B | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3d | College A
College B | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3d | College B
College C | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3d | College C
College C | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3e | College A
College C | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3e | College B
College C | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3e | College C
College C | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3f | College A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3f | College B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3f | College C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | College A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | College B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | College C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3h | College A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3h | College B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3h | College C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3i | College A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3i | College B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3i | College C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3j | College A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3j | College B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3j | College C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3k | College A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3k | College B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3k | College C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3l | College A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3l | College B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3l | College C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3m | College A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3m | College B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3m | College C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3n | College A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3n | College B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3n | College C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3o | College A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3o | College B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3o | College C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | College A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | College B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | College C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | College A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | College B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | College C