Create unique rows in Excel with limited data to be used in multiple columns

Question

I want to make 100 distinct rows with five columns, each containing a different number from a specified list (1, 2, 3, 4, 5, 6, 7). In a row, a number may only be used once.

How can a formula help me with this? At a later stage, comparable unique rows would need to be filled in with fewer columns available as well, therefore a general strategy would be appreciated.

See the illustration provided as an example.

Answer 1

This setup isn't readily generalizable, though since you confirmed that the number of list entries, rows, and columns is fixed:

=LET(α,SEQUENCE(64199,,12345),β,MMULT(0+ISNUMBER(FIND(SEQUENCE(,7),α)),SEQUENCE(7)^0)=5,0+MID(INDEX(SORT(CHOOSE(SEQUENCE(,2),FILTER(α,β),RANDARRAY(SUM(N(β)))),2),SEQUENCE(100)),SEQUENCE(,5),1))