Hidden in Calc's Paste Special option, the Transpose feature enables you to convert data listed across a row, so it appears in a column. This conversion also works on tables, so that header rows ...

But that left open the question of how to deal with JSON objects that your Action methods receive as parameters. I addressed one way of dealing with that in a second column, which showed how to use ...

Fig. 2. shows the mapping of the text file columns to the table columns. Figure 1. Simple data fow from NewStores.txt. Figure 2. How the two text files are mapped. (Click image to view larger ...