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!