How to Code a new column by referencing text in second column?How would I code a new column to fill each cell with a specific text based on the text in a second column? I have a "well" column with A1-A100. I need to create a second column with Treatment "A", for wells A1-A10, "B" for wells A11-A20, etc.
Thanks!
Data Blending and CleanupWindows