to put next column value if row become blank

[paramveer]

i problem in attached sheet. pls solve this issue.
thanks in advance

 

[bosco_yip]

Try,

In B14, formula copied down :

=IF(A14="","",OFFSET($C$6,MOD(ROW(A1)-1,6),INT((ROW(A1)-1)/6)+1))

Regards
Bosco

 

[Peter Bartholomew]

This is a variation on a cross-tab unpivoting exercise.
The parameter and column field are given by
= INDEX(header,[@Row])
= INDEX(grid,[@Row],[@Col])
where the row and column numbers are
=1 + MOD([@k]-1,6)
= CEILING( [@k], 6 ) / 6

 

[paramveer]

Thanks You so much Sir