• VRT (7/9/2015)


    Sorry. If I didnt give proper information.

    I want to do it in the model. Not using query.

    I have seen an online link but its giving error at the final step.

    http://www.sqljason.com/2013/01/group-multiple-rows-to-single-delimited.html

    I think we can do using PowerQuery. We can also do it in PowerPivot but not easy.

    In Power Query it will probably be quite straight forward.

    In the article you linked to, they don't actually group the rows into the model. The number of rows stay the same, they just add the concatenated values to all rows. It's only in the final pivot that you get the aggregated results.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP