I swear I've googled this

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

nvm figured it out

a solution share would be awesome if you did...

Pm sent

No need to be mean...

install gentoo