Creating an array based on different variables

[Sthlm]

Hi, I have run into a little problem which I could use some help with.

I have table with a column with an ID (#) and column with a count. I'd like a dynamic array from this table where the ID (#) is repeated as many times as the count in the same row.
I added an example in attachement, but it's not dynamic at the moment. Adding more rows to the table should extend the array automatically.

Any ideas?

example.xlsx

[djclements]

One way:

Please Login or Register  to view this content.

[Sthlm]

Interesting approach, thanks! It does however make an array much larger than needed with empty rows.

With the warning message up top not to post AI generated solutions I was I inspired to try and find a solution there too. Surprisingly it did come up with a solution that works.
Per regulation I will not post that solution. It also used a TOCOL followed BYROW and SEQUENCE.

I knew about TOCOL but it never came up as a considertion to use it.

[djclements]

It does however make an array much larger than needed with empty rows.

No, it doesn't. See attached...

Blank records in the table "Count" column are treated as 0's. 0 is NOT greater than or equal to SEQUENCE(, MAX(Table1[Count])), so the 0's will return #N/A errors by default with the IFS function. The optional [ignore] argument of TOCOL is set to 2, so it will ignore/remove the errors.

[wk9128]

Cell d2 formula

Please Login or Register  to view this content.