How to have metadata about columns?

[Jean_Pierre_Traets]

Dear @Tim_Richardson1,

Not sure if this post is of your interest, with credits to @Paul_Danyliuk

Transpose table

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 List(…) all the columns you want to be readable from your transposed table. 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 …

Otherwise I would say, why not to experiment by rebuilding your structure with some sample questions, see if this will give the expected result