Showing posts with label Cloud Computing post by Anuj Ng. Show all posts
Showing posts with label Cloud Computing post by Anuj Ng. Show all posts

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?
-----------------------------------------------------------------------------------------------------------------------------------