Forum Discussion

misterJ412's avatar
misterJ412
Copper Contributor
Apr 26, 2022
Solved

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: 

 BranchTreeLemonLeaf
Item 1Branch   
Item 2BranchTree  
Item 3Tree   
Item 4TreeLemon  
Item 5BranchLemon  
Item 6LemonBranchTree 
Item 7BranchLeafTreeLemon
Item 8Leaf   

 

Example for item 3, I would want Tree on the Tree column, etc. Is this possible? Thank you!

Resources