Hi,
Attached is a sample of the data I have created. For the 6th column, I have concatenated the appropriate column headers I need, except I want a space in the middle of each of them, if they are put in the system. I have used the simple method of adding a space between each column header, however, i need the space ONLY between 2 column headers, if and when they are added the 6th column. This is what the formula in the 6th column currently says:
=CONCATENATE(IF(A2="YES",$A$1,""), " ",IF(B2="YES",$B$1,"")," ",IF(C2="YES",$C$1,"")," ",IF(D2="YES",$D$1,""))
However, there are multiple problems with the spacing. I have attached a sample table for an example.
Please let me know how i can remove any spaces in front of the very first column header (text) or more than one spaces between 2 column headers (text). thank you!