Saturday, August 30, 2014

yogi_Formula To Pull Sequential Values From Column A Into Every Sixth Row Of Column C

                      Google Spreadsheet   Post  #1742
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug-30-2014
post by Anuj Ang:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/VSRl1SfBmkc)
Copy list of column into separate column on every nth row
I need some assistance in copying and pasting some cells.

I have a column with data on its rows.
I wish to have the entries of this column pasted into a separate column, BUT on every nth row, while keeping the data continuous.

Here is a screenshot of what I want:

Column N is my raw entries.
And I want them pasted into column H, but on every 10th row.

Is this possible?
-----------------------------------------------------------------------------------------------------------------------------------


No comments:

Post a Comment