Forum Discussion
Place Multiple Categories in a Single Cell?
I'm trying to sort through data I'm inputting manually into a table and I'm wondering how to format a cell. I have a column for categories, and I want to assign one value to multiple categories. Howe...
I have a similar issue. I have collected data with 15 category types, identified with either one or two capital letters (eg: Advert = A or Music and Culture = MC). I have them in a single column with a maximum of three categories per unit, for example, cell C3 reads, 'RP, F, P'. I assigned each letter(s) a number from 1-15 using the SWITCH function but it only works for single category cells. Is there anyway to convert my multiple category cells or will I have to change my collection method/notation?