ryan0521
Board Regular
- Joined
- Dec 7, 2016
- Messages
- 79
Happy new year!
Can anyone help me with this one.
I want to separate values base on their criteria, please see below for the data.
<tbody>
</tbody>
And I want to have a result like this
<tbody>
</tbody>
Thanks in advance
Can anyone help me with this one.
I want to separate values base on their criteria, please see below for the data.
Look up value | Criteria |
100 | Apple |
101 | Apple |
102 | Apple |
103 | Apple |
200 | Ball |
201 | Ball |
202 | Ball |
203 | Ball |
204 | Ball |
300 | Cat |
301 | Cat |
302 | Cat |
<tbody>
</tbody>
And I want to have a result like this
Apple | Ball | Cat | |
1 | 100 | 200 | 300 |
2 | 101 | 201 | 301 |
3 | 102 | 202 | 302 |
4 | 103 | 203 | |
5 | 204 |
<tbody>
</tbody>
Thanks in advance
Last edited: