Show Data in Columns

Newbie question, I ran a report but it's in rows. How can I switch it so that it's in columns? See below currently in rows. I want Links Clicks, Impressions, Frequency, etc. all in row 1, because I'm wanting to use it to import into Google Data Studio


image


  • Hi Mark,


    Thanks for reaching out! One way to achieve this is to set a dimension in the 'split to rows' section that all metrics have in common (like account name). This way you'll end up with something like this:



    The above is the easiest option, but alternatively you can also use Google Sheets' native transpose feature.


    I hope this answers your question!


    Best,

    Menno


    - Supermetrics

Login to post a comment