I would need to display a table/view in a transposed way, with rows as columns. Is that possible?

+1 on being able to toggle table axes for optimized human interaction with certain data sets.

You can in a way. You can Display as Cards and Group Cards by the first Column on the Top side. It’s not a compact view but it can work in cases. [image] Hope this helps. :slight_smile:

Good idea, but like you said, it’s just “kind of working”. Thanks!

Any other idea? It would be nice if we can make a formula refer by column-row.

A makeshift solution, but you can make a separate table that will look up data from your original table in a transposed way. It will be read-only, and you’ll have to manually create row/column mappings. Demo: What you need to do: In the original table, introduce a formula column that will Lis…

Thank you, that is a good suggestion and it would work for me. I see an issue with it however, and that is that if I need to do it for several tables, it’s going to be tedious.

This Transpose problem is one that I’ve been wrestling with for awhile in the world of spreadsheets and just ran into it on Coda. I agree that this would be a really helpful function to include. Since the @superhumans often mention that the Row in Coda is considered the smallest possible unit, it s…

@Geoff_Strout ,nope, this would be a nice to have, but does not exist (yet). writing a transpose function based on hard coded columns in Coda is possible but a bit of work. best, Christiaan

I have been working on a similar project and this solution would work great for me. I have created the column (… List) but now on the transposed table, when I type source, it does not pull anything up in formulas. Am I missing something or is there another way it has to be done since its been upda…

Would like a context menu option to transform the table with a single transpose. Would just make it easier to take common excel spreadsheet data and get it into a format that works well with Coda

Transpose table

Rickard_Abraham March 31, 2023, 4:30am 15

Nice, sweet approach! Also a perfect use case for the column formulas I proposed

Topic		Replies	Views
Rows as columns Product Feedback	6	1540	November 9, 2020
Transpose Rows/Cols of Table - single formula Tips and Hacks	10	2325	March 4, 2024
Is there a way to pull the column name from a table	4	165	April 19, 2025
Allow Users to Transpose Tables Product Feedback	0	369	June 23, 2023
Create table from a list? Tips and Hacks	4	2433	January 28, 2021

Transpose table

Related topics