Re: Transpose row into column
Excellent. I've tried it and it works great.
I call this my transpose Query.
SELECT n.SITE_NETWORK_ID, left(n.ELEMENT_ADDRESS,1) as Sector,
sum(IF(mid(n.ELEMENT_ADDRESS,3)=1,n.cellIdentifierNeighbor,null)) AS row1,
sum(IF(mid(n.ELEMENT_ADDRESS,3)=2,n.cellIdentifierNeighbor,null)) AS row2,
sum(IF(mid(n.ELEMENT_ADDRESS,3)=3,n.cellIdentifierNeighbor,null)) AS row3,
sum(IF(mid(n.ELEMENT_ADDRESS,3)=4,n.cellIdentifierNeighbor,null)) AS row4,
sum(IF(mid(n.ELEMENT_ADDRESS,3)=5,n.cellIdentifierNeighbor,null)) AS row5,
sum(IF(mid(n.ELEMENT_ADDRESS,3)=6,n.cellIdentifierNeighbor,null)) AS row6,
sum(IF(mid(n.ELEMENT_ADDRESS,3)=7,n.cellIdentifierNeighbor,null)) AS row7,
sum(IF(mid(n.ELEMENT_ADDRESS,3)=8,n.cellIdentifierNeighbor,null)) AS row8,
sum(IF(mid(n.ELEMENT_ADDRESS,3)=9,n.cellIdentifierNeighbor,null)) AS row9,
sum(IF(mid(n.ELEMENT_ADDRESS,3)=10,n.cellIdentifierNeighbor,null)) AS row10,
sum(IF(mid(n.ELEMENT_ADDRESS,3)=11,n.cellIdentifierNeighbor,null)) AS row11,
sum(IF(mid(n.ELEMENT_ADDRESS,3)=12,n.cellIdentifierNeighbor,null)) AS row12,
sum(IF(mid(n.ELEMENT_ADDRESS,3)=13,n.cellIdentifierNeighbor,null)) AS row13,
sum(IF(mid(n.ELEMENT_ADDRESS,3)=14,n.cellIdentifierNeighbor,null)) AS row14,
sum(IF(mid(n.ELEMENT_ADDRESS,3)=15,n.cellIdentifierNeighbor,null)) AS row15,
sum(IF(mid(n.ELEMENT_ADDRESS,3)=16,n.cellIdentifierNeighbor,null)) AS row16,
sum(IF(mid(n.ELEMENT_ADDRESS,3)=17,n.cellIdentifierNeighbor,null)) AS row17,
sum(IF(mid(n.ELEMENT_ADDRESS,3)=18,n.cellIdentifierNeighbor,null)) AS row18,
sum(IF(mid(n.ELEMENT_ADDRESS,3)=19,n.cellIdentifierNeighbor,null)) AS row19,
sum(IF(mid(n.ELEMENT_ADDRESS,3)=20,n.cellIdentifierNeighbor,null)) AS row20,
sum(IF(mid(n.ELEMENT_ADDRESS,3)=21,n.cellIdentifierNeighbor,null)) AS row21,
sum(IF(mid(n.ELEMENT_ADDRESS,3)=22,n.cellIdentifierNeighbor,null)) AS row22,
sum(IF(mid(n.ELEMENT_ADDRESS,3)=23,n.cellIdentifierNeighbor,null)) AS row23,
sum(IF(mid(n.ELEMENT_ADDRESS,3)=24,n.cellIdentifierNeighbor,null)) AS row24
FROM nbr_table n
where n.handoverClass >0
group by n.SITE_NETWORK_ID,sector
ORDER BY n.SITE_NETWORK_ID