Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Carriage return values in matrix

Hi,

 Is there any option in matrix that values to be carriage return. for example: I have values like below :

Note: i want it in single cell not into multiple rows.

From:

A,B,C

 To:

A
B
C

 

The above i can able to do in edit queries section but when i click "close and apply". The column which i have formatted like above is not coming. Values are  automatically displayed in single line. 

Output:

I want to see in "DATA" section as below:

A,B,CA
B
C
C,D,EC
D
E
E,G,HE
G
H
H,I,KH
I
K

 

 

Thanks,

Prasanth.C

  • Anonymous ,

     

    Based on my test, I'm afraid the data view doesn't suppot multiple lines in a cell. 

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support

    Anonymous ,

     

    Based on my test, I'm afraid the data view doesn't suppot multiple lines in a cell. 

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.