Pivot Query

[#1]

Hi all,

i have data in the below format:

Task	Comments	Date
BBPLC for Swap	01 Oct: - Migration of Non US Population off BCSL	10/20/2016
BBPLC for Swap	01 Oct: - Migration of Non US Population off BCSL	10/19/2016
BCI -Enhancement	12 Oct: -House Position and House ladder protype ready -Actuals Vs Projections Reconciliation and MTM prototype ready	10/20/2016
BCI -Enhancement	12 Oct: -House Position and House ladder protype ready -Actuals Vs Projections Reconciliation and MTM prototype ready	10/19/2016

and i want to create a pivot table which will display the result as the below format:

Task	Comments	Date
BBPLC for Swap	01 Oct: - Migration of Non US Population off BCSL	10/20/2016
	01 Oct: - Migration of Non US Population off BCSL	10/19/2016
BCI -Enhancement	12 Oct: -House Position and House ladder protype ready -Actuals Vs Projections Reconciliation and MTM prototype ready	10/20/2016
	12 Oct: -House Position and House ladder protype ready -Actuals Vs Projections Reconciliation and MTM prototype ready	10/19/2016

Where Date is sorted with recent date and Date column is hidden

please advise

thanks

Sukhwant

[Frank_Hartmann]

then try like:

=Concat(distinct Comments, ', ')

hope this helps

[#3]

thanks it worked. last thing now is how to sort the comments based on Date column?

thanks in advance

[Frank_Hartmann]

without a datedimension i think its not possible to change sortorder within a field in pivottable.

I think then you will have to go with a straight table and hide the date collumn.

hope this helps