5 Replies Latest reply on Mar 7, 2018 10:09 AM by Deepak Rai

    Join multiple rows into a single row

    Aby Jacob

      Hi All,

       

      I am facing a problem. I want to join multiple rows into a single row by concatenating  the values of a column and separate them by ","

      Please find attached my workbook for reference.

      I have arranged the data in the following order:

      Store Number, Store Name, State, Market, Department, Project Name, Status.

      The problem is that there are some store-project combination with multiple departments and there are multiple rows for each department.

      I want to display one row in that case and concatenate the departments by ","