6 Replies Latest reply: Jan 30, 2017 2:30 PM by Vineeth Pujari RSS

    Transposing column headings to field values (1000+)

    John Martin

      I have a two dimensional array of customers vs dates , together with values where these intersect.


      I've found manual solutions posted here for smaller ranges, but a manual solution isn't really feasible in this instance.


      Is there a way to take a row header + first column and convert those into dimensions , with the value at intersection as a measure?


      The endgame is to be able to chart the various customers over a date range, and select the various customer names as a filter.


      Is this possible?


      Thanks again for any advice - am hoping this is a fairly standard request!