Need to show values as columns

Question

Hello All,&nbsp;I am having data like&nbsp;&nbsp;I want the status values as column names and count below the respective column status values.&nbsp;&nbsp;I mean, &nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp;Version 1.0Draft| Published| Confirmed2 &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;31 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;___________________________3 &nbsp; &nbsp;| &nbsp; &nbsp;3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| &nbsp;4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (total)&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;Version 2.0Draft| Published| Confirmed2 &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;31 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1___________________________3 &nbsp; &nbsp;| &nbsp; &nbsp;3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| &nbsp;4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (total)&nbsp;I want to get each version has how many drafts, published, e.t.c&nbsp;Please suggest me how can i get.&nbsp;Thank you in advance.&nbsp;&nbsp;&nbsp;

bsas · Accepted Answer

Hi,&nbsp;Try to play with matrix visual.

Forum Discussion

Need to show values as columns

2 Replies

Related content

Splitting Column values

Matching Column Values

Check column for similar values

Retrieving Values from Single Column

Change column values based on different column values