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.
What is the source of this Excel file?
Hi Jan,
Thank you for your response. What do you mean by that?
- 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.