Use SPLIT to create a new, independent cell for each colour in Column G. A spreadsheet function called SPLIT separates text around a given character and places each fragment in a new, distinct cell.
What tool would you employ to look for a specific value in a spreadsheet column?
When data is listed in columns, the vertical lookup function, or VLOOKUP, is utilised. This process looks for a value in the left-most column and compares it to information in a certain column in the same row. In a sorted or unsorted table, you can use VLOOKUP to find data.
Learn more about commas
https://brainly.com/question/14588824
#SPJ4