Hi i have table in this below form.
description |
Category |
count |
Z |
Available |
27.0 |
Z |
Not Available |
14169.0 |
Z |
Less Available |
863.0 |
Y |
Available |
50.0 |
Y |
Not Available |
58971.0 |
Y |
Less Available |
888.0 |
OTHER |
Available |
380.0 |
OTHER |
Not Available |
272343.0 |
OTHER |
Less Available |
3231.0 |
X |
Available |
1564.0 |
X |
Not Available |
1313.0 |
X |
Less Available |
3087.0 |
How can i transform same into result view like below:
description |
Avaialble |
Less Available |
Not Available |
X |
1,564 |
3,087 |
1,313 |
Y |
50 |
888 |
58,971 |
Z |
27 |
863 |
14,169 |
OTHER |
380 |
3,231 |
272,343 |