6 Replies Latest reply on May 3, 2018 5:07 PM by evan silverberg

    Having trouble pivoting data

    evan silverberg

      I am having trouble pivoting data, an action I have done multiple times. I am working with a data set that includes a couple hundred stock tickers, a dozen or so fields, and the field value. Each unique ticker is spread over multiple rows, as this is the way the data was given to me. I want to consolidate each ticker into 1 row, then have the fields be the column headers, with the value in the corresponding cell. I keep failing when trying to do so. Any help would be greatly appreciated. I have attached a screen shot of how the data is presented, but have to sub the actual data for an example for work reasons.