Forum Discussion
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 l...
- 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.
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.
Do you have any idea how to approach this problem? I'm trying to find a solution last 3 days, couldn't find anything helpful. Thanks in advance
Meceka I used the Data, From Table button to reshape the data, see attached. From there you can use formulas using the now split up columns to achieve what you need.
JKPieterse result I want need to look like this.
- 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.
JKPieterse this seems broken or you misunderstand me.
