Hi guys,

is there any options how to use one data source for multiple rows.

Example, I use titles as information of tmie of each athlete. We use 4 lanes, so i worked it around as for each lane different datasource (same google sheet). But i would like to use it from data source. Like first row is option selected but for rest of 3 lanes i would like to use other 3 rows below that and at same time be able to move rows.

Example Row1 time of athlete n1
Row2 time of athlete n2
Row3 time of athlete n3
Row4 time of athlete n4

and then
Row5 time of athlete n1
Row6 time of athlete n2
Row7 time of athlete n3
Row8 time of athlete n4
ëtc.

via script i am somehow able to work it out but it's not suitable for rest of the crew

Also, Look at utilising some of the functionality within Google sheets to format the data before it hits mix, I Find the transpose function very useful , an example can be found at the link below that uses multiple sheets to sort and format for vmix


https://docs.google.com/...ayxcQoI/edit?usp=sharing