Hi, I am quite inexperienced in R and I'm having a problem resolving an issue that I have. I'm not quite where to start resolving it in R, but I have not managed to do so in openrefine.
I have a spreadsheet with multiple columns. Column G contains a
number of codes that all have different meanings. For example, 02 means X, 0207 means y, but is a subset of X, 03 means something entirely different. What I want to do is split column G into multiple columns, where every "02" is contained in its own column called "02" for example, and the same for all the other codes. What's been happening when I tried this in openrefine (which i am more familiar with as I am so new to R) is I end up with 100's of columns and nothing is ordered. Ie not all the "02" in one column and "0105" in their own column and so on and so forth. How would I approach this? I will add a photo of column G as an example. Please advise?