Hi

I have posted this erroneously in excel programming. Sorry for posting
in 2 separte groups.

I am using the illustration below to explain my problem.


1 2 3 4 5 and so on

1 "Val1"
2 "Val2"
3 "Val3"
4
5


In another cell, I have a value "say" 6. In the first row, I want
"Val1" to be copied from Column 2 to Column 6 (6 entries). By the same
logic, in ROW 2, "Val2" will be copied from Column 3 to Column 7.

Is there a way of doing this using formulae or function?


Best Regards
Prasad