I am trying to find a formula that will allow me to populate the cells in a column with the value from the first cell above it in that column. I have attached a sample workbook and a picture of the worksheet. In the sample, I am trying to concatenate cells A,B, and C into D with each having a color, number, and letter. Please help. If I have been unclear, I can try to clarify. Thank you.
Bookmarks