Forum Discussion
misterJ412
Apr 26, 2022Copper Contributor
Moving to other columns based on cell value
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!
3 Replies
- SergeiBaklanDiamond Contributor
- misterJ412Copper Contributorworks like a charm, thanks!
- SergeiBaklanDiamond Contributor
misterJ412 , you are welcome