B 1 Enter the formula: =RANDBETWEEN( 1, 102), and drop it down to b102; ;
Then sort B 1, which can randomly disrupt the sorting of a and b,
Then enter 1- 102 from A 1 to A 102, and you can get that column A is the table number and column B is the group number.