I have a bit of a logic problem I'm trying to figure out. I have data that has inconsistent attributes and I want to figure out if I can programmatically extract the data: My data has a SINGLE column. Column A reflects the individual entries and the attributes associated with them. Column B is my data:
<tbody>
</tbody>
I would prefer to get output leveraging only three rows:
Banans Yellow Shipped Arrived damaged
Apples Red En-route TBD
Grapes Green TBD
I was trying to leverage a nested IF statement and since I have over 100 entries, I don't want to copy/paste (transpose).... Any suggestions?
1 | Bananas |
2 | Yellow |
3 | Shipped |
4 | Arrived |
5 | damaged |
1 | Apples |
2 | Red |
3 | En-route |
4 | TBD |
1 | Grapes |
2 | Green |
3 | TBD |
<tbody>
</tbody>
I would prefer to get output leveraging only three rows:
Banans Yellow Shipped Arrived damaged
Apples Red En-route TBD
Grapes Green TBD
I was trying to leverage a nested IF statement and since I have over 100 entries, I don't want to copy/paste (transpose).... Any suggestions?
Last edited: