Viewing 1 to 4 of 4 items
Tag Archives: Google Spreadsheet

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),”;”))

0

Using Google Spreadsheets as a CMS with PHP

As seen here: http://elikirk.com/using-google-spreadsheets-as-a-cms-with-php/ Setup a Published Google Spreadsheet Create a Google spreadsheet, then fill in the data in your spreadsheet with an identifier in one column and the content in the next column. Next, we need to publish the content. Note: This is more than just “Sharing” the spreadsheet. When you to this, your  Full Article…

0