Transpose table

#1

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

4 Likes
#2

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

#3

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.


Hope this helps. :slight_smile:

#4

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

1 Like
#5

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

#6

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:

  1. In the original table, introduce a formula column that will List(…) all the columns you want to be readable from your transposed table.
  2. In the transposed table, make as many columns as there are rows in the original table, and to each of them assign a formula in the fashion:
    Source.[Row as list].Nth(X).Nth(thisRow.RowId())
    where X is the constant number of this column.

Note that using RowId() is fine unless you ever delete rows from your transposed table. If you delete rows you’ll lose continuity in row IDs and will need something else as an index (e.g., a column with explicitly set values, or a row index as implemented here).

#7

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.