'Fixture List' table needed

Hello there and thank you for taking the time to read my post.
I am looking for some assistance with a 'fixture list' type table for job comparisons
Please see the attached Excel example which I have manually put together. The list of Jobs could be in the 100's if not thousands and I, therefore, need to automate this part of the process!

The simplest way to describe my need is like a football league arrangement. There is a list of teams and I need to create a table of Team A versus Team B. In my case, they are jobs not teams.

PART 1
I need to create the 'fixture list' initially for each job to appear in the fixture table. This can then be used to manually enter a result. (I do not need help with this part)

PART 2
It is likely that I will need to compare Job A with Job B, C, D etc but only once and not in a home and away type situation. For example, I do not need Job A v Job B and then Job B v Job A

Ideally I would like the overall ordering to be completely random, so not AvB, AvC, AvD etc.... all mixed up such as AvB, DvF, GvC, EvA etc.

I am happy to have helper columns because once random generator has been done I will cut and paste the values into a new sheet to 'fix' the output.

I hope all that makes sense, I find it very difficult to explain what I am wanting to achieve, however I hope the attached explains a little better.

Thank you to anyone who can offer me help, I do appreciate it.

I don't understand this.
here is my guess.

H6:I10

=INDEX(Table1[Description],AGGREGATE(15,6,Table1[JobRef]/NOT(COUNTIF($H$5:$I5,Table1[Description]))/(Table1[Description]<>G6),RANDBETWEEN(1,MAX(Table1[JobRef])-ROWS(G$6:G6)*2+COLUMNS(H6:$I6))))

Press Ctrl+Enter

Press F9 to random

Thank you, considering you did not understand you have worked the solution very well, I appreciate that.

The solution is great for Part 1 of my requirement, each description appears only once in the table. How can I answer the need of Part 2,extend it so that each description appears against each other once?

For example AvC, AvD, etc, BvD, BvE etc?

It's such a shame you have a Mac! I have a ready-made PowerQuery solution that would have been perfect.

@AliGW - I can run windows on my mac too in order to do the generation if required?

No, it's the version of Excel (Excel for Mac) you have that doesn't support it - sorry.

Let me explain. I have a partition on my MAc which basically means I run windows. On there I run Excel for Windows, not for MAC. I have to use this method for creating forms for example.
If you are able to share your solution that would be most helpful.
Thank you

OK - in that case, I will move your thread back and you need to update your forum user profile!!!

So, you need to load the table you have to PQ and first create from it a list of jobs, which you load to connection only. Then this M Code:

Please Login or Register  to view this content.

Please try

Formula:

Please Login or Register  to view this content.

Administrative Note:

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

Originally Posted by Bo_Ry

Please try

Formula:

Please Login or Register  to view this content.

Thank you. This helps a lot. I appreciate your time.

Originally Posted by AliGW

OK - in that case, I will move your thread back and you need to update your forum user profile!!!

I don't see the need to update my user profile. I am a mac user and that is my main operating system. Mac users have the ability to run windows and therefore windows software as an alternative where required. Since you mentioned PQ was the solution, I mentioned the ability.

Originally Posted by AliGW

Administrative Note:

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

"Brought to your attention"? How very Machiavellian!
If it is such a problem then please delete the post.
On the other forum there was no ability to upload a workbook, hence why I reverted to this forum.
If the forums are not connected I don't see what the issue is but to be quite honest if this is the sort of response then I wont bother in future.

I have a solution from Bo_Ry that works and without any fuss. I will let you get back to your moderating and the lofty position that projects you to.