Extract data from a matrix
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
aka_ash
8 - Asteroid
‎11-24-2021
04:41 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi
I am looking to extract data from cells in a large excel matix.
I have a sample below with 3 different sets of data in a cell.
Below is the input and 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 |
Labels:
- Labels:
- Transformation
1 REPLY 1
cmcclellan
13 - Pulsar
‎11-24-2021
10:14 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator