One column with different questions in the same table

Question

I have one table with this dataAssignment groupMetricValueString valueticket number&nbsp;Value is the question we make to the employees like:what did you like most about our serviceWe are sorry that you did not have a service as you expected&nbsp;and 3 more like this&nbsp;The string value is the comment to the value data like&nbsp;value&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;string valuewe are sorry bla bla bla&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; your service is not good enough and i need more sweets in my tab&nbsp;I would like to achieve something like this&nbsp;Ticket number&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;assignment group&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; value&nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string value 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; value 2&nbsp; &nbsp; &nbsp; &nbsp;string value 2inc0000123&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IT FRance&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; we are sorry bla bla&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;my table is full of dust&nbsp; &nbsp; &nbsp; &nbsp; what bla bla&nbsp; &nbsp;i like all&nbsp;&nbsp;&nbsp;but unfortunatelly what i have achieved is this&nbsp;Ticket number&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;assignment group&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; value&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string value&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;inc0000123&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IT FRance&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; we are sorry bla bla&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;my table is full of dust&nbsp; &nbsp;&nbsp;inc0000123&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IT FRance&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;what bla bla&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; i like all&nbsp;&nbsp;&nbsp;Any idea how can I achieve this?, a matrix visual is not the solution as I don´t want to expand the ticket number to see the assignment group etc&nbsp;Thanks!

v-juanli-msft · Accepted Answer

Hi&nbsp;Anonymous&nbsp;
If you'd like this output,

please check my method below:
In Edit queries,
1. sort rows on Ascending-&gt; first sort by "Ticket number", second by "assignment group",
&nbsp; &nbsp; then add an index column from 1

2. select "value" and "string value" columns, then select "unpivot columns",

3. add conditional column

4. merge columns

5. Close&amp;&amp;apply
Add columns into a matrix,
select the icon on the top-right of the matrix which means :expand all down one level

In Format setting, turn off Row header-&gt;Stepped layout,
turn off row/column subtotal,
&nbsp;
To make the columns show as the order of your example,
please select the column "Merged" which is added into "Column" field of the matrix,
then select "Modeling"-&gt;Sort by column-&gt;select "rank_2" column,

Best RegardsMaggieCommunity Support Team _ Maggie LiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
&nbsp;
&nbsp;

Forum Discussion

One column with different questions in the same table

2 Replies

Related content

Bookmark questions

Clustered column chart question

Architecture question and brainstorming

Unpivot Question

Field Parameter Question