Transform table to result view
Hi i have table in this below form.
How can i transform same into result view like below:
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 |