could you please elaborate ! as in why and how.

i Don't know but in less time than it took to make these virtual vMix views (or duplicate the same request you already made a while ago and claimed it was to much work) i edited the textblock names in the title code (ranking graphics) according to the "convert rows to collumns" option and the subsequent headernames as per the help for auto: "a) Will first look for the first column with the same name as the Title field"

so say its a file with no specific header names as per your excel example the names in the textblock names in the title would be :
for first row : Column11, Column21, Column31,...
second row : Column12, Column22, Column32,...
and so on

but that's just how i did it ;-)

Some else along these same lines that I cannot find any other place. would be the ability to link cells in a group, for example for a lower third a name of joe doe, ceo of abc company and title of his speech would all be tied together so as you change speakers you only change the name and the other information will come along from the spreadsheet.

We created a spreadsheet that when you type in the page number of any hymn, excel finds the title and vMix displays it in a lower third.
Once you learn how to use spreadsheets and data sources it becomes a very powerful tool.