Feb 06, 2018 05:41 PM
Is there a way to rotate / transpose an airtable base? We want the columns to be the rows and vice versa.
Feb 07, 2018 08:19 AM
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.
Feb 07, 2018 08:26 AM
I think you can also do it downloading a CSV, doing it in Excel (or similar), and then importing the CSV.
Feb 08, 2018 12:12 AM
Yes, in a spreadsheet you can actually select the cells, copy them, and PASTE SPECIAL (TRANSPOSE).
Mar 15, 2018 07:37 AM
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!
May 15, 2019 11:16 AM
Hi, How do you do the transpose in the blocks? I viewed the pivot table link but did not see it. Thank you! Also, is it possible to do a complimentary trial to Pro at this time? Lastly, how can I see the gallery view and ideally also Kanban view on an iPhone?
Apr 14, 2020 09:39 AM
Hi Katherine, is there still no way to do a table transpose? By transpose i mean the transpose function in excel. I don’t think we do it in airtable. Really need this feature urgently thank you