I have a spreadsheet where I need to combine 9 columns. These columns contain words, not data. All 9 columns need to be combined into one column so I can upload to my CRM system. Some columns contain information, some do not and are left blank. I can combine the rows using CONCATENATE but here's...