```
https://graph.microsoft.com/v1.0/groups/{group_id}/members/microsoft.graph.device
```

### Step-by-Step Guide:

**Create a List of Letters A to Z**:

- In a separate column (say Column D), create a list from A to Z. You can do this manually by typing each letter or using the formula
`=CHAR(ROW(A1)+64)`

and dragging it down for 26 rows.

**Expand Each Row for 26 Letters**:

- In a new sheet (or below your existing data), you’ll want to replicate each row 26 times and add the corresponding letter from A to Z.
- Here’s how you can do it:

#### Step 1: Set Up the Original Data

Assume your original data is in cells `A2:C6`

with headers in row 1.

#### Step 2: Create the Sequence of Letters

In column D (starting from `D1`

), create the list of letters A to Z.

Letter |
---|

A |

B |

C |

… |

Z |

#### Step 3: Generate the New Dataset

You can use the following approach to expand the data:

**Create a New Sheet**:

- Go to a new sheet where you want the expanded data.

**Fill Down the Original Data**:

- In the new sheet, for the Email column, use the formula to repeat each email 26 times:
`=INDEX(Sheet1!A$2:A$6, INT((ROW(A1)-1)/26) + 1)`

Drag this formula down to cover all the rows. - For the Tier column:
`=INDEX(Sheet1!B$2:B$6, INT((ROW(B1)-1)/26) + 1)`

Drag this formula down as well. - For the Machine column:
`excel =INDEX(Sheet1!C$2:C$6, INT((ROW(C1)-1)/26) + 1)`

Drag this formula down.

**Add the Alphabet Column**:

- In the new sheet, create the A-Z sequence next to each set of 26 rows:
`excel =INDEX(Sheet1!D$1:D$26, MOD(ROW(D1)-1,26)+1)`

Drag this formula down.

This method will give you an expanded dataset with each original row repeated 26 times, with the last column containing letters A to Z.

### Example Output:

Tier | Machine | Letter | |
---|---|---|---|

example1@mail.com | Gold | Machine1 | A |

example1@mail.com | Gold | Machine1 | B |

… | … | … | … |

example1@mail.com | Gold | Machine1 | Z |

example1@mail.com | Silver | Machine1 | A |

… | … | … | … |

example3@mail.com | Silver | Machine1 | Z |

This will give you the desired result where each original entry is repeated 26 times with letters A to Z in the new column.