Distribute a table

[Mamdouh Elfors]

Hi

I have the first table I want to distribute the numbers in this table horizontally in the form of the second table

Thanks

 

[bosco_yip]

In G3, copied across and down :

=IF(ROW(A1)-MOD(COLUMN(A1)-1,3)-1<=0,OFFSET($D$2,MATCH(G$2,$C$3:$C$14,0)+ROW(A1)-MOD(COLUMN(A1)-1,3)-1,0),"")

Regards
Bosco

 

[Mamdouh Elfors]

Thank you very much Bosco
and great effort

 

[Mamdouh Elfors]

Hi
I have another request
Can the numbers be distributed in the first table from the beginning of the month to a specified number of months?
Attachment file for clarification
Thanks

 

[Luiz Carlos]

Hello!
Check the spreadsheet and make a comeback.

 

[Mamdouh Elfors]

This is OK
Thanks Luiz