Sequential array

[zelarra]

Hi guys.

What I need is pretty simple.

I have this table:

Well, you have to repeat each cell in the column as many times as the same cell in column H, so that you get this:

Thanks.

 

[hagia_sofia]

Please test this:

=TOCOL(IF(ISNUMBER(DROP(REDUCE("",H2:H5,LAMBDA(a,b,VSTACK(a,SEQUENCE(,b)))),1)),E2:E5,NA()),2)

 

[zelarra]

Solved. Thanks a lot.

 

[Fluff]

A slightly shorter option

=TOCOL(IF(SEQUENCE(,MAX(H2:H100))<=H2:H100,E2:E100,1/0),2)

 

[zelarra]

Thanks!!!!

 

[Fluff]

Glad we could help & thanks for the feedback.