rows and columns

[mv5757]

I want to be able to pick up values in say 20 individual rows from 10 columns. The column to be used have a value of 1 or 0. The column to be used is the column with a 1. So where the column has a value of 1 then each of the 20 rows in that column have to be copied to another column. If the column with the value of 1 changes then the rows to be copied need to change.

 

[My Aswer Is This]

We always need specific details. None of which you provided.
You said:

in say 20 individual rows from 10 columns
What columns?
What rows?

You said:

each of the 20 rows in that column have to be copied to another column

What other column?​

​