I have a large selection of excel sheets that surveys were taken on. A column comprises of a question and then the user selects a 1-5 answer on the column to the left of the question. The problem stems from the fact that the answer options are made available via tick boxes that the user checks.
When i try to use
readxl to import the data, the answer columns are all null. The checkboxes are being ignored. Does anyone know of a package that might handle this? I have seen a question but in a python context on stackoverflow
Thank you very much for your time