creating new column and presenting data from 2 different columns

[arieta]

Hello, I have some issues on presenting certain data from a file in a specific way.I have two columns in my file that look like columns A and B. Based on column B, I would like column A to state specific data as the example below. Please consider that my data comprise of multiple rows.

Column A (as is now)	Column B(as is now)	Column C (as I want it to be)
ALL SUBTYPES	-	ALL SUBTYPES
ALL SUBTYPES	APPLE	KIWI
ALL SUBTYPES	-	ALL SUBTYPES
ALL SUBTYPES	-	ALL SUBTYPES
ALL SUBTYPES	APPLE-NEGATIVE	KIWI
ALL SUBTYPES	-	ALL SUBTYPES
ALL SUBTYPES	ONE BANANA	KIWI
ORANGE	ORANGE	ORANGE
PINEAPPLE	PINEAPPLE	PINEAPPLE

Thank you!

[fmvizcaino]

Hi @arieta ,

You can use an IF function to present the data as you need.

IF IsNull([Column B(as is now)]) or [Column A (as is now)]=[Column B(as is now)]
then [Column A (as is now)]
else 'Kiwi'
endif

Best,

Fernando Vizcaino

[arieta]

Hi @fmvizcaino, 

Thanks a lot for the reply! It worked this way, however, just understood that I presented my data a bit differently than they actually are. Please see below a more accurate example: 

Column A (as is now)	Column B(as is now)	Column C (as I want it to be)
ALL SUBTYPES	-	ALL SUBTYPES
ALL SUBTYPES	APPLE	KIWI
ALL SUBTYPES	-	ALL SUBTYPES
ALL SUBTYPES	-	ALL SUBTYPES
ALL SUBTYPES	APPLE-NEGATIVE	KIWI
ALL SUBTYPES	-	ALL SUBTYPES
ALL SUBTYPES	ONE BANANA	KIWI
TRIPLE-NEGATIVE	CHERRY	TRIPLE NEGATIVE
TRIPLE NEGATIVE	WATERMELON	TRIPLE NEGATIVE
ORANGE	ORANGE	ORANGE

Mainly the change is the bold rows. So, when 'triple-negative' is presented in Column A, I would like to also exist in Column C. Could you please help me with this? 

Thank you!

[jeff_reynolds · Accepted solution]

Hi. See attached workflow. It uses Fernando's formula, with an extra step to add in your updated logic.