Tuesday, March 27, 2018

yogi_ Rearrange Two Groups Of Items In Range A1:H1 Separated By A Blank Cell Into Reange L2:M

Google Spreadsheet   Post  #2406

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Mar-27-2018
transpose list
Hi im trying to transpose 2 list the first list would get the info from A1 to whatever cell is empty in row 1 so if A1,B1,C1 as value and D1 was empty it would transpose the value of A1,B1,C1 in L1 then the second list would start from the next cell from the empty cell so if D1 was empty and E1,F1,G1,H1 as value then my second transpose list in M1 would have the value of E1,F1,G1,H1
Here's a link to a sample sheet


Thanks