I am trying to bring text data from multiple worksheets into a final worksheet by using concatenate...unfortunately i cannot figure out how to have it remove the rows with no text data, it just places a blank line instead. This makes the cell extremely large when it doesn't need to be.
Here is an example of my formula: =CONCATENATE('Beaty, PJ'!K7,CHAR(10),'Bubela, G'!K7,CHAR(10),'Carreon, P'!K7,CHAR(10),'Cope, K'!K7,CHAR(10),'Cummings, PC'!K7,CHAR(10),'Hagemeier, D'!K7,CHAR(10),'Hasty, B'!K7,CHAR(10),'Higgins, J'!K7,CHAR(10)) Any help will be greatly appreciated.
Bookmarks