Create schedule view chart with set number of rows per date

[BlondeThursday]

We have a need to create a schedule chart of events at each of four venues. Each venue can have up to four events on each day.

The finished chart should have four rows for every date and start time and class for each of the venues in separate columns.

Please see the attached spreadsheet - two tabs, first is sample input data and the second is the desired output.

Any points would be much appreciated.

Thank you

[Arthur_Fong]

Update the script in the screenshot with this:

let vVenueName1= peek('Venue',0,'VenueRow');
//This loop is to join back all Venues back to the first table
for i=1+1 to $(vNum)
let vVenueName= peek('Venue',$(i)-1,'VenueRow');
trace $(vVenueName);
join($(vVenueName1))
$(vVenueName):
load *
resident $(vVenueName);
Drop table $(vVenueName);
next i

drop table tempData;

Thanks and regards,

Arthur Fong