Transpose table

[Rickard_Abraham]

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

New formulas for columns

Goal Dynamically select a column from a table Issue The current possible approach forces you to repeat yourself into a coupled mess: Select Options Formula List("Population", "Area", "Density", "GDP", "Elevation", "Temp") Dynamic Column Formula Switch( [Select], "Population", thisRow.Population, "Area", thisRow.Area, "Density", thisRow.Density, "GDP", thisRow.GDP, "Elevation", thisRow.Elevation, "Temp", thisRow.Temp ) If you want to add a column you need to modify informati…