I am compiling data into a metadata file. I would like to combine all columns into one combined column by concatenating or some other formula. However, some columns I want to concatenate are "N/A", which I do not want to include. Also, I want to capture the different concentrations (copies/µl) for the names in the wells, but I am unsure how to do this neatly. I have included a screenshot of the columns as an example. Can someone please assist?
