Can you make this formula smaller? I have been trying to for hours.
=IF(B1"",B1&CHAR(10),"")&IF(C1"",C1&CHAR(10),"")&IF(D1"",D1&CHAR(10),"")&IF(E1"",E1&CHAR(10),"")&IF(F1"",F1&CHAR(10),"")&IF(G1"",G1&CHAR(10),"")&IF(H1"",H1&CHAR(10),"")&IF(I1"",I1&CHAR(10),"")&IF(J1"",J1&CHAR(10),"")&IF(K1"",K1&CHAR(10),"")&IF(L1"",L1&CHAR(10),"")&IF(M1"",M1&CHAR(10),"")&IF(N1"",N1&CHAR(10),"")&IF(O1"",O1&CHAR(10),"")&IF(P1"",P1&CHAR(10),"")
Attached: download.jpg (267x189, 13K)
what in the actual fuck are you trying to do?
That's really easy to do actually
Pull cells in to one cell with line breaks while ignoring empty cells. I know this is probably 100% not the way to do it...
If you could share how easy thatd be lovely
a solution share would be awesome if you did...