Thanks Winon, that will be helpful but the project column is a living file which will be added once there are new projects. In that case, I will always have to revise the concatenate formula since it's until row 36. Is there any other formula that I don't have to revise everytime that there is an added data on the project column?
Bookmarks