Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can try simple way also by use of pivot table and add dimensions
Dim1:- [Col A]
Dim2:- [Col B]
And Expression =1
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.
You can try simple way also by use of pivot table and add dimensions
Dim1:- [Col A]
Dim2:- [Col B]
And Expression =1
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.