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.

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

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