Forum Discussion

CHARLEA1's avatar
CHARLEA1
Frequent Visitor
4 years ago
Solved

Unmerging dataset

Hi there,  I have data that is strangely structured like the following: ColumnA   ColumnB A                 B B                 C and I want to find a way to conver the data to the following...
Need Help
  • CHARLEA1's avatar
    CHARLEA1
    4 years ago

    Following up with this thread that I have solved my issue via merging my table with the same table referencing column B as column A

Thingsclump's avatar
Thingsclump
Resolver V
4 years ago

Hi CHARLEA1 

 

Did you try using a custom function to generate column C?  This function can take values from column B and check against column A.

 

I can visualise the steps in my mind and guess it will work.

 

Thanks

www.thingsclump.com