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.