Pool Team Name Team Code Pool Seed Team Name Team Code
R1A SCVC 14Quiksilver (SC) b14scvbc1sc R1A
43
 SCVC 14Quiksilver (SC) b14scvbc1sc
R1A SASVBC B 14-1 (AH) b14spser1ah R1A
2
 SASVBC B 14-1 (AH) b14spser1ah
R1A Cinci Attack 14 Black (OV) b14cattk1ov R1A
22
 Cinci Attack 14 Black (OV) b14cattk1ov
R1A LEGACY-TAMPA 14 (FL) b14lgacy1fl R1A
4
 LEGACY-TAMPA 14 (FL) b14lgacy1fl
R1B C2 Attack 14-1 SMACK (SO) b14cavbc1so R1B
42
 C2 Attack 14-1 SMACK (SO) b14cavbc1so
R1B SBVC Boys 14-1 (SC) b14sbarb1sc R1B
40
 SBVC Boys 14-1 (SC) b14sbarb1sc
R1B MVP 14 Black (CH) b14mvpjo1ch R1B
7
 MVP 14 Black (CH) b14mvpjo1ch
R1B UC ELITE 14U Oliver (NC) b14ucelt1nc R1B
38
 UC ELITE 14U Oliver (NC) b14ucelt1nc
R1C Balboa Bay 14Blue (SC) b14balby1sc R1C
9
 Balboa Bay 14Blue (SC) b14balby1sc
R1C MUV 14 National Sebi (FL) b14muted1fl R1C
37
 MUV 14 National Sebi (FL) b14muted1fl
R1C The St. James Boys 14 N (CH) b14stjam1ch R1C
11
 The St. James Boys 14 N (CH) b14stjam1ch
R1C Pipeline 14-1 (GL) b14pipev11gl R1C
12
 Pipeline 14-1 (GL) b14pipev11gl
R1D BORINQUEN COQUI 14-1M (PU) b14coqui1pu R1D
13
 BORINQUEN COQUI 14-1M (PU) b14coqui1pu
R1D MVVC B 14 Red (NC) b14mouvi1nc R1D
35
 MVVC B 14 Red (NC) b14mouvi1nc
R1D Roch PaceBootleggr14 Blk (WE) b14paceb1we R1D
15
 Roch PaceBootleggr14 Blk (WE) b14paceb1we
R1D WAVE 14-Nicole (SC) b14wvevb1sc R1D
34
 WAVE 14-Nicole (SC) b14wvevb1sc
R1E Pinnacle 14-JP (SC) b14pnncl1sc R1E
17
 Pinnacle 14-JP (SC) b14pnncl1sc
R1E MKE Sting 14-1 Adam (BG) b14mlwst1bg R1E
18
 MKE Sting 14-1 Adam (BG) b14mlwst1bg
R1E Future 14-Elite (GL) b14futre1gl R1E
19
 Future 14-Elite (GL) b14futre1gl
R1E Kali 14-1 M (PU) b14397891pu R1E
20
 Kali 14-1 M (PU) b14397891pu
R1F HPSTL B14 Royal (GW) b14hpstl1gw R1F
21
 HPSTL B14 Royal (GW) b14hpstl1gw
R1F TORRI 14-1 (PU) b14torri1pu R1F
1
 TORRI 14-1 (PU) b14torri1pu
R1F OCVC14-1 (SC) b14ocvbc1sc R1F
23
 OCVC14-1 (SC) b14ocvbc1sc
R1F Elevation 14 Peak Boys (RM) b14elevb1rm R1F
33
 Elevation 14 Peak Boys (RM) b14elevb1rm
R1G MDJRS 14 Boys Open (CH) b14mdjrs1ch R1G
25
 MDJRS 14 Boys Open (CH) b14mdjrs1ch
R1G COAST Boys 14-Bela (SC) b14coast1sc R1G
32
 COAST Boys 14-Bela (SC) b14coast1sc
R1G Warren Sixpack 14-1 (GE) b14waren1ge R1G
31
 Warren Sixpack 14-1 (GE) b14waren1ge
R1G 630 Volleyball 14-1 (GL) b14630vb1gl R1G
28
 630 Volleyball 14-1 (GL) b14630vb1gl
R1H Aspire 14 Groot (AZ) b14aspir1az R1H
29
 Aspire 14 Groot (AZ) b14aspir1az
R1H Ultimate B14 Gold (GL) b14ultim1gl R1H
30
 Ultimate B14 Gold (GL) b14ultim1gl
R1H JJVA Boys 14 Teal (FL) b14jaxjr1fl R1H
3
 JJVA Boys 14 Teal (FL) b14jaxjr1fl
R1H SPORTIME 14-1 (GE) b14sptmc1ge R1H
26
 SPORTIME 14-1 (GE) b14sptmc1ge
R1I Bay to Bay 14-1 (NC) b14bytby1nc R1I
27
 Bay to Bay 14-1 (NC) b14bytby1nc
R1I Academy 14 Adidas (HO) b14tavbc1ho R1I
41
 Academy 14 Adidas (HO) b14tavbc1ho
R1I HVA 14 YOUNG GUNS RED (LS) b14hvavb1ls R1I
14
 HVA 14 YOUNG GUNS RED (LS) b14hvavb1ls
R1I Adversity 14 Adidas (GL) b14adver1gl R1I
36
 Adversity 14 Adidas (GL) b14adver1gl
R1J MB Surf ASICS 14's 1 (SC) b14mbssv1sc R1J
8
 MB Surf ASICS 14's 1 (SC) b14mbssv1sc
R1J MOD B14 Blue (GL) b14modvb1gl R1J
24
 MOD B14 Blue (GL) b14modvb1gl
R1J Orlando Gold 14 Black (FL) b14ogold1fl R1J
39
 Orlando Gold 14 Black (FL) b14ogold1fl
R1J EXCEL 14N Red (NT) b14excel1nt R1J
5
 EXCEL 14N Red (NT) b14excel1nt
R1K VAQUEROS 14-1 (PU) b14vaque1pu R1K
16
 VAQUEROS 14-1 (PU) b14vaque1pu
R1K Team Rockstar 14 Rockstar (SC) b14rstar1sc R1K
6
 Team Rockstar 14 Rockstar (SC) b14rstar1sc
R1K WPVC Boys 14 Armour Black (FL) b14wpvcb1fl R1K
10
 WPVC Boys 14 Armour Black (FL) b14wpvcb1fl


Code:
// Table1
let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    EmptyTable = Table.IsEmpty(Source),
    Idx = if not EmptyTable then Table.AddIndexColumn(Source, "Index", 1, 1, Int64.Type) else Source,
    RowCount = Table.RowCount(Idx),
    RandomOrder = if not EmptyTable then GenerateRandomOrder(RowCount) else {},
    RandomIndex = Table.AddColumn(Idx, "Seed", each if not EmptyTable then RandomOrder{[Index] - 1} else null, Int64.Type),
    TSC = Table.SelectColumns(RandomIndex,{"Pool", "Seed", "Team Name", "Team Code"})
in
    TSC
Code:
// GenerateRandomOrder
let
    GenerateRandomOrder = (count) =>
        let
            randomList = List.Numbers(1, count),
            shuffledList = List.Buffer(List.Sort(randomList, each Number.Random()))
        in
            shuffledList
in
    GenerateRandomOrder