| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
1 | this is what I have | I need to map the values to the column corresponding to their type | |||||
2 | data 1 | data 2 | data 3 | type 1 | type 2 | type 3 | |
3 | <span type="type 1">data 1-1</span> | <span type="type 2">data 2-1</span> | <span type="type 3">data 3-1</span> | <span type="type 1">data 1-1</span> | <span type="type 2">data 2-1</span> | <span type="type 3">data 3-1</span> | |
4 | <span type="type 3">data 3-2</span> | <span type="type 1">data 1-2</span> | <span type="type 2">data 2-2</span> | <span type="type 1">data 1-2</span> | <span type="type 2">data 2-2</span> | <span type="type 3">data 3-2</span> | |
5 | <span type="type 2">data 2-3</span> | <span type="type 3">data 3-3</span> | <span type="type 1">data 1-3</span> | <span type="type 1">data 1-3</span> | <span type="type 2">data 2-3</span> | <span type="type 3">data 3-3</span> | |