Can multiple cell values be combined into a single cell?

[#1]

Hi,

I have a requirement as follows:

Col A     Col B

123         aaa

234         bbb

123         ccc

456         ddd

123         eee

I need to get the result as below in single cell in separate lines(col B) i.e aaa,ccc and eee which belongs to 123 must be displayed in a single cell one below the other as shown below.

A                        B

123                 1)aaa

                       2)ccc

                       3)eee

--------------------------------

234                 1)bbb

-------------------------------

456                 1)ddd

[#2]

Maybe by using this expression:

Concat(DISTINCT [Col B], chr(10))

I used it in a pivot table with Col A as dimension, and then under the Presentation tab > Wrap Cell Text: 3 lines.

[its_anandrjs · Accepted solution]

You can try simple way also by use of pivot table and add dimensions

Dim1:- [Col A]

Dim2:- [Col B]

And Expression =1

[its_anandrjs]

From another one you can try see the example for that

Tab1:

LOAD * INLINE [

    Col A, Col B

    123, aaa

    234, bbb

    123, ccc

    456, ddd

    123, eee   ];

LOAD

[Col A],

[Col A] as A,

AutoNumber(RowNo(),[Col A])&Chr(41)&[Col B] as B;

LOAD * INLINE [

    Col A, Col B

    123, aaa

    234, bbb

    123, ccc

    456, ddd

    123, eee    ];

And on the front end take pivot table and add dimensions A and B

Note:- And Un check the option Suppress Zero-Value from chart Presentation properties.