Forum Discussion

Meceka's avatar
Meceka
Copper Contributor
Nov 24, 2021
Solved

How to copy values in comma seperated data into another column conditionally

There is a sample excel file below. Each value in column A has corresponding order in column D. For example in A2 first line 'False' is matched with 'Countryside Mobility Newsletter' and the second line 'True' is matched with the second value after the comma in column D 'Deaf Led Services Information'. 

 

My target is if there is at least one true in column A, it should print "opt-in" in column B. İf there is nothing, the column remains blank.

Also if there is at least one true in column A, it's corresponding part in column D should print column C. 

 

İs there any formula to do that? I appreciate any help.

  • There isn't anything broken there, just a different representation of your data, which makes it easier to use the TRUE's and FALSE's.

8 Replies

    • Meceka's avatar
      Meceka
      Copper Contributor

      Hi Jan,

      Thank you for your response. What do you mean by that?

      • JKPieterse's avatar
        JKPieterse
        Silver Contributor
        Well, given the structure of the data in your screenshot I suspect the file wasn't actually an Excel file, but e.g. a (poorly formatted) CSV file.

Resources