6 Replies Latest reply: Nov 14, 2011 9:18 AM by Przemysław Wojda RSS

    Adjust pivot table to show all value split by chr(10)

    Przemysław Wojda

      Hi,

       

      I'm looking for and idea how to show all values of an expression split by chr(10) - enter. In the the attached example this would be showing 3 rows for John i.e. A, B and C, not just A.

       

      Any help appreciated.

       

      Kind regards,

      Przemek