Hi
I am looking to extract data from cells in a large excel matrix.
I have a sample below with 3 different sets of data in a cell.
Below is the input and an expected output
ideally i will expand the output further by splitting the 3 data identifiers in the cells
Matrix input:
| | Data 1 | Data 2 | Data 3 | Data 4 | Data 5 |
| Data 1 | |
1:Low
2:High
3:High |
1:Low
2:Low
3:High |
1:Low
2:High
3:High |
1:Low
2:High
3:Low |
| Data 2 | | |
1:High
2:High
3:High |
1:Low
2:High
3:High |
1:Low
2:High
3:High |
| Data 3 | | | |
1:Low
2:High
3:High |
1:Low
2:High
3:High |
| Data 4 | | | | |
1:Low
2:Low
3:High |
initial output:
| Title 1 | Title 2 | Output |
| Data 1 | Data 1 | |
| Data 1 | Data 2 |
1:Low
2:High
3:High |
| Data 1 | Data 3 |
1:Low
2:Low
3:High |
| Data 1 | Data 4 |
1:Low
2:High
3:High |
| Data 1 | Data 5 |
1:Low
2:High
3:Low |
| Data 2 | Data 1 | |
| Data 2 | Data 2 | |
| Data 2 | Data 3 |
1:High
2:High
3:High |
| Data 2 | Data 4 |
1:Low
2:High
3:High |
| Data 2 | Data 5 |
1:Low
2:High
3:High |
| Data 3 | Data 1 | |
| Data 3 | Data 2 | |
| Data 3 | Data 3 | |
| Data 3 | Data 4 |
1:Low
2:High
3:High |
| Data 3 | Data 5 |
1:Low
2:High
3:High |
| Data 4 | Data 1 | |
| Data 4 | Data 2 | |
| Data 4 | Data 3 | |
| Data 4 | Data 4 |
|
| Data 4 | Data 5 |
1:Low
2:High
3:High |
