Speed Networking Seating Schedule

Speed networking is when attendees spend time at a table (known as a Round) with other attendees, during the time at the table each attendee gives a 1 minute commercial. At the end the time period, the attendees change tables and meet new people. My problem is how do I create this schedule in excel with the following criteria:
45 attendees
5 rounds
6 tables with 9 seats at each table.
I want a schedule that has the following column headers (see attached):
Round 1, Round 2, Round 3, Round 4, Round 5, Attendee
Under the Round columns I want to generate the table number they are assigned to for that round. The key is that attendees only see each other 1 time at most.