Spreadsheet: 677969d1589639745-power-query-extract-data-from-cells-to-build-a-table-of-data-for-analysis-book3
Sheet: Sheet3

Date 06.05.2020 | Column1 | Column2 | Column3 | Column4 | Column7 | Column8 |  | Date 06.05.2020 | Column1 | Column2 | Column3 | Column4 | Column7 | Column8 |  | Date | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9
SECTION 1 |  |  |  |  |  |  |  | SECTION 1 | Executive Summary |  | G | Board are happy |  |  |  | SECTION 1 | Executive Summary |  | G | Board are happy
Executive Summary |  |  | G | Board are happy |  |  |  | SECTION 1 | Executive Summary |  | G | Everything on track |  |  |  | SECTION 1 | Executive Summary |  | G | Everything on track
Executive Summary |  |  | G | Everything on track |  |  |  | SECTION 2 | Issue | Description |  |  |  | Status |  | SECTION 2 | Issue | Description |  |  |  |  |  | Status
SECTION 2 |  |  |  |  |  |  |  | SECTION 2 | 1 | Section 2, Text 1 |  |  |  | A |  | SECTION 2 | 1 | Section 2, Text 1 |  |  |  |  |  | A
Issue |  | Description |  |  |  | Status |  | SECTION 2 | 2 | Section 2, Text 2 |  |  |  | A |  | SECTION 2 | 2 | Section 2, Text 2 |  |  |  |  |  | A
1 |  | Section 2, Text 1 |  |  |  | A |  | SECTION 2 | 3 | Section 2, Text 3 |  |  |  | A |  | SECTION 2 | 3 | Section 2, Text 3 |  |  |  |  |  | A
2 |  | Section 2, Text 2 |  |  |  | A |  | SECTION 3 | 1 | Section 3, Text 1 |  |  |  |  |  | SECTION 3 | 1 | Section 3, Text 1 |  |  |  | Accounts
3 |  | Section 2, Text 3 |  |  |  | A |  | SECTION 4 |  |  |  |  |  | Status |  | SECTION 4 |  |  |  |  |  |  | Status
SECTION 3 |  |  |  |  |  |  |  | SECTION 4 |  | Section 4, Text 1 |  |  | G |  |  | SECTION 4 |  | Section 4, Text 1 |  |  |  |  | G
1 | Section 3, Text 1 |  |  |  |  |  |  | SECTION 4 |  | Section 4, Text 2 |  |  | G |  |  | SECTION 4 |  | Section 4, Text 2 |  |  |  |  | G
SECTION 4 |  |  |  |  | Status |  |  | SECTION 4 |  | Section 4, Text 3 |  |  | G |  |  | SECTION 4 |  | Section 4, Text 3 |  |  |  |  | G
Section 4, Text 1 |  |  |  |  | G |  |  | SECTION 4 |  | Section 4, Text 4 |  |  | G |  |  | SECTION 4 |  | Section 4, Text 4 |  |  |  |  | G
Section 4, Text 2 |  |  |  |  | G |  |  | SECTION 5 |  | Section 5, Text 1 |  |  |  |  |  | SECTION 5 |  | Section 5, Text 1
Section 4, Text 3 |  |  |  |  | G |  |  | SECTION 5 |  | Section 5, Text 2 |  |  |  |  |  | SECTION 5 |  | Section 5, Text 2
Section 4, Text 4 |  |  |  |  | G |  |  | SECTION 6 |  | Section 6, Text 1 |  |  |  |  |  | SECTION 6 |  | Section 6, Text 1
SECTION 5 |  |  |  |  |  |  |  | SECTION 6 |  | Section 6, Text 2 |  |  |  |  |  | SECTION 6 |  | Section 6, Text 2
Section 5, Text 1 |  |  |  |  |  |  |  | SECTION 6 |  | Section 6, Text 3 |  |  |  |  |  | SECTION 6 |  | Section 6, Text 3
Section 5, Text 2 |  |  |  |  |  |  |  | SECTION 7 |  | Section 7, Text 1 |  |  |  |  |  | SECTION 7 |  | Section 7, Text 1
SECTION 6 |  |  |  |  |  |  |  | SECTION 7 |  | Section 7, Text 2 |  |  |  |  |  | SECTION 7 |  | Section 7, Text 2
Section 6, Text 1 |  |  |  |  |  |  |  | SECTION 7 |  | Section 7, Text 3 |  |  |  |  |  | SECTION 7 |  | Section 7, Text 3
Section 6, Text 2 |  |  |  |  |  |  |  | SECTION 7 |  | Section 7, Text 4 |  |  |  |  |  | SECTION 7 |  | Section 7, Text 4
Section 6, Text 3 |  |  |  |  |  |  |  | SECTION 8 |  | Section 8, Text 1 |  |  |  |  |  | SECTION 8 |  | Section 8, Text 1
SECTION 7 |  |  |  |  |  |  |  | SECTION 8 |  | Section 8, Text 2 |  |  |  |  |  | SECTION 8 |  | Section 8, Text 2
Section 7, Text 1 |  |  |  |  |  |  |  | SECTION 8 |  | Section 8, Text 3 |  |  |  |  |  | SECTION 8 |  | Section 8, Text 3
Section 7, Text 2 |  |  |  |  |  |  |  | SECTION 9 |  | Section 9, Text 1 |  |  |  |  |  | SECTION 9 | Recommendation 1 | Section 9, Text 1 | Status | A
Section 7, Text 3 |  |  |  |  |  |  |  | SECTION 9 | Recommendation 1 | Section 9, Text 1 | Status | A |  |  |  | SECTION 9 |  | Section 9, Text 2
Section 7, Text 4 |  |  |  |  |  |  |  | SECTION 9 |  | Section 9, Text 2 |  |  |  |  |  | SECTION 9 |  | Section 9, Text 3
SECTION 8 |  |  |  |  |  |  |  | SECTION 9 |  | Section 9, Text 3 |  |  |  |  |  | SECTION 9 |  | Section 9, Text 4
Section 8, Text 1 |  |  |  |  |  |  |  | SECTION 9 |  | Section 9, Text 4 |  |  |  |  |  | SECTION 9 |  | Section 9, Text 5
Section 8, Text 2 |  |  |  |  |  |  |  | SECTION 9 |  | Section 9, Text 5 |  |  |  |  |  | SECTION 9 |  | Section 9, Text 6
Section 8, Text 3 |  |  |  |  |  |  |  | SECTION 9 |  | Section 9, Text 6 |  |  |  |  |  | SECTION 9 | Recommendation 2 | Section 9, Text 7 | Status | A
SECTION 9 |  |  |  |  |  |  |  | SECTION 9 | Recommendation 2 | Section 9, Text 7 | Status | A |  |  |  | SECTION 9 |  | Section 9, Text 8
Recommendation 1 | Section 9, Text 1 | Status | A |  |  |  |  | SECTION 9 |  | Section 9, Text 8 |  |  |  |  |  | SECTION 9 |  | Section 9, Text 9
Section 9, Text 2 |  |  |  |  |  |  |  | SECTION 9 |  | Section 9, Text 9 |  |  |  |  |  | SECTION 9 |  | Section 9, Text 10
Section 9, Text 3 |  |  |  |  |  |  |  | SECTION 9 |  | Section 9, Text 10 |  |  |  |  |  | SECTION 9 |  | Section 9, Text 11
Section 9, Text 4 |  |  |  |  |  |  |  | SECTION 9 |  | Section 9, Text 11 |  |  |  |  |  | SECTION 9 |  | Section 9, Text 12
Section 9, Text 5 |  |  |  |  |  |  |  | SECTION 9 |  | Section 9, Text 12 |  |  |  |  |  | SECTION 9 |  | Section 9, Text 13
Section 9, Text 6 |  |  |  |  |  |  |  | SECTION 9 |  | Section 9, Text 13 |  |  |  |  |  | SECTION 9 |  | Section 9, Text 14
Recommendation 2 | Section 9, Text 7 | Status | A |  |  |  |  | SECTION 9 |  | Section 9, Text 14 |  |  |  |  |  | SECTION 9 |  | Section 9, Text 15
Section 9, Text 8 |  |  |  |  |  |  |  | SECTION 9 |  | Section 9, Text 15 |  |  |  |  |  | SECTION 9 | Recommendation 3 | Section 9, Text 16 | Status | A
Section 9, Text 9 |  |  |  |  |  |  |  | SECTION 9 | Recommendation 3 | Section 9, Text 16 | Status | A |  |  |  | SECTION 9 |  | Section 9, Text 17
Section 9, Text 10 |  |  |  |  |  |  |  | SECTION 9 |  | Section 9, Text 17 |  |  |  |  |  | SECTION 9 |  | Section 9, Text 18
Section 9, Text 11 |  |  |  |  |  |  |  | SECTION 9 |  | Section 9, Text 18 |  |  |  |  |  | SECTION 9 |  | Section 9, Text 19
Section 9, Text 12 |  |  |  |  |  |  |  | SECTION 9 |  | Section 9, Text 19 |  |  |  |  |  | SECTION 9 |  | Section 9, Text 20
Section 9, Text 13 |  |  |  |  |  |  |  | SECTION 9 |  | Section 9, Text 20 |  |  |  |  |  | SECTION 9 |  | Section 9, Text 21
Section 9, Text 14 |  |  |  |  |  |  |  | SECTION 9 |  | Section 9, Text 21 |  |  |  |  |  | SECTION 9 |  | Section 9, Text 22
Section 9, Text 15 |  |  |  |  |  |  |  | SECTION 9 |  | Section 9, Text 22 |  |  |  |  |  | SECTION 9 |  | Section 9, Text 23
Recommendation 3 | Section 9, Text 16 | Status | A |  |  |  |  | SECTION 9 |  | Section 9, Text 23 |  |  |  |  |  | SECTION 9 |  | Section 9, Text 24
Section 9, Text 17 |  |  |  |  |  |  |  | SECTION 9 |  | Section 9, Text 24
Section 9, Text 18
Section 9, Text 19
Section 9, Text 20
Section 9, Text 21
Section 9, Text 22
Section 9, Text 23
Section 9, Text 24