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 |
Solved! Go to Solution.
@aka_ash
I think maybe a Transpose tool?