10 Replies Latest reply: Sep 15, 2017 2:28 AM by Joshua Solomon RSS

    Cross table

    Joshua Solomon

      Hi all,

      I want to convert the following columns vertically as Branch

      0854 - GXWFI0855 - GXOAS0857 - GXBU10859 - GXGAZ0860 - GXFRA0861 - GXHDB0862 - GXPLD0863 - GXNHD0864 - GXHMN0865 - GXMAC0866 - GXARM0868 - GXTCM0869 - GXFRD0870 - GXNTT0872 - GXUAQ0873 - GXMZY0874 - GXBRJ0877 - GXQOZ0878 - GXDIA

      and following columns vertically as hypermarket

      AjmanDeiraAl Saqr ADHRAK ManarMarina MallJimmy MallSharjahShindagaCentury MallMall of EmiratesAl Ain BawadiRAK Zaith 2Dalma Store AUHMirdiffBaniyasFuj Cent Mall

      pls find the attached excel.

       

       

      Regards,

      Joshua