I have a spreadsheet on Google Sheets with essentially 2 tables. The below is an example of what it looks like, but my data is more complex and with a wider range.
In the first set of data or table, in the rows down I have items, and in the columns across I have categories. Each Item (row) has ticks in 3 of the categories. I want to represent this data in the second table, whereby in the rows down there are the same items, but instead the columns show the actual value (from the header) that are ticked in the first table.
As an example, Item 1 has A, C and E ticked, so in the second table, as shown I want to have the values 'A' (appear in J5), 'C' (in K5) and 'E' (in L5). Right now I've just manually typed in the category that corresponds with the tick according to the item in the row, but my original data has over 30 categories and only 3 are selected for each item (row), I want to present it so I can see the value of what is selected. Is there a formula I can use to do this, I'm thinking something along the lines of using an IF function whereby the cell is not blank?
In the first set of data or table, in the rows down I have items, and in the columns across I have categories. Each Item (row) has ticks in 3 of the categories. I want to represent this data in the second table, whereby in the rows down there are the same items, but instead the columns show the actual value (from the header) that are ticked in the first table.
As an example, Item 1 has A, C and E ticked, so in the second table, as shown I want to have the values 'A' (appear in J5), 'C' (in K5) and 'E' (in L5). Right now I've just manually typed in the category that corresponds with the tick according to the item in the row, but my original data has over 30 categories and only 3 are selected for each item (row), I want to present it so I can see the value of what is selected. Is there a formula I can use to do this, I'm thinking something along the lines of using an IF function whereby the cell is not blank?