I would like get a screenshot of categorised data re participation by dept.
I exported data in Excel but I wanted to categorise data automatically e.g.
ACI - Design - AR11 to be categorised as ACI or Design or AR11. I can do this manually but I realised that this the way the data has been imported e.g. displaying ACI - Design - AR11 instead of the I described above. After the survey has been launched and we ha already started to see results would it be possible to amend the data we imported?
I hope the above makes sense.