Hello all - I am trying to figure out how to merge columns in a spreadsheet, under a specified condition.
Hopefully I can explain this clearly.... Situation: I have created a drop down list in column D.... when someone picks specific items in that drop down, I would like the blank cells in columns E, F, & G to automatically merge to one large cell (this is in regards to format, not content merge). However, if other items in the drop down are selected, no merge is to occur. the Merge formatting needs to be unique to each row, as each item is selected. Is this possible?