Forum Discussion
Meceka
Nov 24, 2021Copper Contributor
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
- JKPieterseSilver ContributorWhat is the source of this Excel file?
- MecekaCopper Contributor
Hi Jan,
Thank you for your response. What do you mean by that?- JKPieterseSilver ContributorWell, 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.