I am looking for a formula to transform a source table like this:
- City name Berlin New York Paris
Population 3769495 8175133 2148271
Area 891 783 105
…to a single-column, YAML -ish format, with the first column as labels:
- City name: Berlin
Population: 3769495
Area: 891
- City name: New York
Population: 8175133
Area: 783
- City name: Paris
Population: 2148271
Area: 105
Is there something smarter / more efficient than manually copying cell references? I’ll need this to work with a fairly large table.
I fiddled around with Transpose and Offset, but just can’t get it to work.
Thank you.