# Draft

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

### Step-by-Step Guide:

1. 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.
1. 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.

#### Step 3: Generate the New Dataset

You can use the following approach to expand the data:

1. Create a New Sheet:
• Go to a new sheet where you want the expanded data.
1. 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.
`excel =INDEX(Sheet1!D\$1:D\$26, MOD(ROW(D1)-1,26)+1)`