Hello everyone,
I'm a bit stuck here and would appreciate your help as I couldn't find a similar case.
I have some data in 4 different columns, and I want specific data to only be on specific columns, and blank on the rest.
Example:
| | Branch | Tree | Lemon | Leaf |
| Item 1 | Branch | | | |
| Item 2 | Branch | Tree | | |
| Item 3 | Tree | | | |
| Item 4 | Tree | Lemon | | |
| Item 5 | Branch | Lemon | | |
| Item 6 | Lemon | Branch | Tree | |
| Item 7 | Branch | Leaf | Tree | Lemon |
| Item 8 | Leaf | | | |
Example for item 3, I would want Tree on the Tree column, etc. Is this possible? Thank you!
