You are viewing an old revision of this post, from September 2, 2015 @ 15:13:00. See below for differences between this version and the current revision.

Useful Google Spreadsheets Transpose Cell Values

=transpose(split(join(";",B:B)&join(";",C:C)&join(";",D:D)&join(";",E:E)&join(";",F:F)&join(";",G:G)&join(";",H:H)&join(";",I:I)&join(";",J:J)&join(";",K:K)&join(";",L:L)&join(";",M:M)&join(";",N:N)&join(";",O:O)&join(";",P:P)&join(";",Q:Q)&join(";",R:R)&join(";",S:S)&join(";",T:T)&join(";",U:U)&join(";",V:V)&join(";",W:W)&join(";",X:X)&join(";",Y:Y)&join(";",Z:Z),";")) =transpose(split(join(";",AA:AA)&join(";",AB:AB)&join(";",AC:AC)&join(";",AD:AD)&join(";",AE:AE)&join(";",AF:AF)&join(";",AG:AG)&join(";",AH:AH)&join(";",AI:AI)&join(";",AJ:AJ)&join(";",AK:AK)&join(";",AL:AL)&join(";",AM:AM)&join(";",AN:AN)&join(";",AO:AO)&join(";",AP:AP)&join(";",AQ:AQ)&join(";",AR:AR)&join(";",AS:AS)&join(";",AT:AT)&join(";",AU:AU)&join(";",AV:AV)&join(";",AW:AW)&join(";",AX:AX)&join(";",AY:AY)&join(";",AZ:AZ),";")) =transpose(split(join(";",BA:BA)&join(";",BB:BB)&join(";",BC:BC)&join(";",BD:BD)&join(";",BE:BE)&join(";",BF:BF)&join(";",BG:BG)&join(";",BH:BH)&join(";",BI:BI)&join(";",BJ:BJ)&join(";",BK:BK)&join(";",BL:BL)&join(";",BM:BM)&join(";",BN:BN)&join(";",BO:BO)&join(";",BP:BP)&join(";",BQ:BQ)&join(";",BR:BR)&join(";",BS:BS)&join(";",BT:BT)&join(";",BU:BU)&join(";",BV:BV)&join(";",BW:BW)&join(";",BX:BX)&join(";",BY:BY)&join(";",BZ:BZ),";")) =transpose(split(join(";",CA:CA)&join(";",CB:CB)&join(";",CC:CC)&join(";",CD:CD)&join(";",CE:CE)&join(";",CF:CF)&join(";",CG:CG)&join(";",CH:CH)&join(";",CI:CI)&join(";",CJ:CJ)&join(";",CK:CK)&join(";",CL:CL),";"))

Revisions

  • September 2, 2015 @ 15:13:00 [Current Revision] by PeterLugg
  • September 2, 2015 @ 15:13:00 by PeterLugg

Revision Differences

There are no differences between the September 2, 2015 @ 15:13:00 revision and the current revision. (Maybe only post meta information was changed.)

Tags: ,

No comments yet.

Leave a Reply