Complex Data Transfer

[KMVKMVKMV]

Hello all,

I will appreciate your help on the following case:
A large amount of data (cells A2, A3, A4 etc) needs to be transferred into a "new" Sheet. The tricky part is every piece of data of the "old" Sheet (e.g. A2) is required to be multiplied x 5 in the "new" Sheet. In other words, "A2" from the "old" sheet will now be distributed as A2:A6 in the "new" Sheet. With that said, it is tricky to automize the transfer process. What formula/function/manipulation would you suggest using in such case?

NOTE: Please find attached an Excel file with short example and explanations which would make it easier for you to understand the issue.

Let me know if you want me to clarify on something.

Thank you for your time.

[JohnTopley]

Try

in A2

=INDEX(Code!$A$2:$A$10,INT((ROWS($1:1)-1)/6+1))

copy down

In your sheet it ia A2:A7. If really should be A6 i.e. 5 entries then change 6 to 5 in the above formula

[zbor]

Another way, based not on number 6 but where is first day of the month:

Please Login or Register  to view this content.

Change ; to , if you get error.

[TudyBTH]

hi,

put this in A2 and drag down

Please Login or Register  to view this content.

se attached

[KMVKMVKMV]

Hi guys,

It seems that all of your suggestions work fine.

Thank you!