Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
700
Column Grouping....Need solution
posted

I have records as below

Country  Color        Men Women
India       RED         5        6
India       Blue         10      12
USA       RED         7        7
USA       GREEN    6         8
UK         Blue         5         9
UK         RED        12        18

Need to produce the following output..

                  RED                 BLUE              GREEN
Country  Men Women       Men Women     Men Women
India       5        6               10      12           0      0
USA       7        7                0       0             6      8
UK         5        9                5       8             0      0

 

Can someone help me to solve this ?