shortcuts wrote:
Please help to find out how to copy every 30th cell in the column into
consecutive cells in another one.
Thanks
Let A2:A1000 house the source data and C2 the first destination cell.
In B2 enter & copy down:
=INDEX($A$2:$A$1000,(ROW()-ROW(C$2))*3+1)
|