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

June 19, 2022 / 1 minute of reading

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