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


  • 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!



    - Supermetrics

Login to post a comment