=load(
  local!x:1,
  local!data: {
    {name:"n1",designation:"des1",address:"addrs1"},
    {name:"n2",designation:"des2",address:"addrs2"},
    {name:"n3",designation:"des3",address:"addrs3"}
  },
  local!pagingInfo: a!pagingInfo(startIndex: 1, batchSize: -1,sort: a!sortInfo(field: "id", ascending: true)),
  with(
    local!datasubset: todatasubset(local!data, local!pagingInfo),
    a!formLayout(
      firstColumnContents:{
    a!gridField(
      label: "SAIL EXAMPLE: Transpose Rows/Columns in a table",
      totalCount: local!datasubset.totalCount,
      columns: {
        a!gridTextColumn(
          label: "",
          field: "id",
          data:if(mod(x,2)=0, index(local!datasubset.data, "name", {}),{local!datasubset.data.name[1],local!datasubset.data.designation[1],local!datasubset.data.address[1]} ),
          alignment: "LEFT"
        ),
        a!gridTextColumn(
          label: "",
          field: "name",
          data:if(mod(x,2)=0, index(local!datasubset.data, "designation", {}),{local!datasubset.data.name[2],local!datasubset.data.designation[2],local!datasubset.data.address[2]} )
          ),
        a!gridTextColumn(
          label: "",
          field: "department",
          data:if(mod(x,2)=0, index(local!datasubset.data, "address", {}),{local!datasubset.data.name[3],local!datasubset.data.designation[3],local!datasubset.data.address[3]}) 
          )
      },
      value: local!pagingInfo,
      saveInto: local!pagingInfo
    )},
    buttons:{
      a!buttonLayout(
        secondaryButtons:{
          a!buttonWidget(
            label:"Transpose",
            value:local!x+1,
            saveInto:local!x,
            style:if(mod(x,2)=0,"DESTRUCTIVE","PRIMARY")
                  )
                 }
                )
    }
    )
    
  )
)