Transpose / Rotate Base


#1

Hi there,

Is there a way to rotate / transpose an airtable base? We want the columns to be the rows and vice versa.

Thanks!


#2

I believe you would have to do this manually. If you have access to Blocks (Pro plan or beta user), there is a Pivot Table block which may provide something of what you are looking for, but I have a feeling you will need to copy your table and recreate it.


#3

I think you can also do it downloading a CSV, doing it in Excel (or similar), and then importing the CSV.


#4

Yes, in a spreadsheet you can actually select the cells, copy them, and PASTE SPECIAL (TRANSPOSE).


#5

Regarding what Alex said above—we just released the Airtable Blocks platform today. Blocks is normally a feature for Pro and Enterprise users only, but we’re giving everyone a free trial of Blocks until the end of Saturday, March 31. Check it out—it might be relevant to your interests!