copy x lines from a column in excel to a new column

i use this function: =INDEX($A$1:$A$20,ROW(C1)+(48*(COLUMNS($C$1:C$1)-1))) on C1 cell and copy until C48 then copy to many collunms, works.

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top