# Is it possible to pivot data from Rows to Columns?



##### Post Metadata
- Posted at: about 4 years ago
- Author title: Marketing analyst
- Net upvotes: 1


## Comments
### Comment 1

Hi James,

Absolutely! For example, both our Google Sheets and Microsoft Excel destinations support splitting data by rows or columns. When creating your query and selecting which dimensions to split the data by, simply choose whether you want to split the data to rows or columns.

Additionally, you of course have all of the native reporting tools at your disposal, such as the transpose command in both Google Sheets and Microsoft Excel.

Pivoting data works in a number of our other destinations as well. Feel free to let me know exactly which destination you're working with and I'd be happy to give more detailed instructions.

Best,
Aleks

##### Comment Metadata
- Posted at: about 4 years ago
- Author title: Head of Product Marketing




## Related Product
[Supermetrics](https://www.g2.com/products/supermetrics/reviews)

## Related Category
[Marketing Analytics](https://www.g2.com/categories/marketing-analytics)

## Related discussions
- [How well does Trello scale into a larger team?](https://www.g2.com/discussions/1-how-well-does-trello-scale-into-a-larger-team)
  - Posted at: about 13 years ago
  - Comments: 6
- [Can we please add a new section](https://www.g2.com/discussions/2-can-we-please-add-a-new-section)
  - Posted at: about 13 years ago
  - Comments: 0
- [Quantifiable benefits from implementing your CRM](https://www.g2.com/discussions/quantifiable-benefits-from-implementing-your-crm)
  - Posted at: about 13 years ago
  - Comments: 4