Thread: Inquiry Thanks: 0 Likes: 0

1. Inquiry

Good day guys!

For example i have a set of data from sheet1 from column 1 to 10
A1 0
B1 0
C1 0
D1 2
E1 34
F1 65
G1 32
H1 23
I1 15
J1 90

How can I transfer it to Sheet 2 and it will:
*transfered all values to rows
*it will transfer all values starting with the non zero value(in my example it must start with 2 etc.)

2. Re: Inquiry

Originally Posted by Duwin
For example i have a set of data from sheet1 from column 1 to 10
A1 0
B1 0
C1 0
D1 2
E1 34
F1 65
G1 32
H1 23
I1 15
J1 90

How can I transfer it to Sheet 2 and it will:
*transfered all values to rows
When you say transferred to rows (plural), do you actually mean "across columns in a single row"? I would note your values are already in rows.

3. Re: Inquiry

Originally Posted by Rick Rothstein
When you say transferred to rows (plural), do you actually mean "across columns in a single row"? I would note your values are already in rows.
Sorry my bad..for example i have it in sheet 1 row a1 to j1

How can I transfer it to Sheet 2 and it will:
*transfered all values to one column
*it will transfer all values starting with the non zero value(in my example it must start with 2 etc.)

4. Inquiry

Good day guys!

For example i have a set of data from sheet1 from A1 to J1
A1 0
B1 0
C1 0
D1 2
E1 34
F1 65
G1 32
H1 23
I1 15
J1 90

How can I transfer it to Sheet 2 and it will:
*transfered all values to column A1 to A10
*it will transfer all values starting with the non zero value(in my example it must start with 2 etc.)

5. Re: Inquiry

Assuming original data in Sheet 1, enter this formula into A1 of sheet 2, then drag down.

=IFERROR(AGGREGATE(15,6,1/(1/SHEET!!\$A\$1:\$J\$1),ROWS(A\$1:A1)),"")

6. Re: Inquiry

Originally Posted by jasonb75
Assuming original data in Sheet 1, enter this formula into A1 of sheet 2, then drag down.

=IFERROR(AGGREGATE(15,6,1/(1/SHEET!!\$A\$1:\$J\$1),ROWS(A\$1:A1)),"")
Thanks jason..it worked but the transfered values become increasing..is it possible to retain the same sequence of numbers..for example it will copy to sheet 2

A1 2
B1 34
C1 65
D1 32
E1 23
F1 15
G1 90

7. Re: Inquiry

I have merged your two threads with the same question together. Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will typically be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.

8. Re: Inquiry

Originally Posted by Joe4
I have merged your two threads with the same question together. Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will typically be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.
Im so Sorry joe..it will not happen again 😔

9. Re: Inquiry

[QUOTE=Duwin;5345647]is it possible to retain the same sequence of numbers../QUOTE]
In that case, try

=IFERROR(INDEX(Sheet1!\$A\$1:\$J\$1,AGGREGATE(15,6,COLUMN(Sheet1!\$A\$1:\$J\$1)/(Sheet1!\$A\$1:\$J\$1<>0),ROWS(A\$1:A1))),"")

10. Re: Inquiry

[QUOTE=jasonb75;5345753]
Originally Posted by Duwin
is it possible to retain the same sequence of numbers../QUOTE]
In that case, try

=IFERROR(INDEX(Sheet1!\$A\$1:\$J\$1,AGGREGATE(15,6,COLUMN(Sheet1!\$A\$1:\$J\$1)/(Sheet1!\$A\$1:\$J\$1<>0),ROWS(A\$1:A1))),"")
It copied it in row but still in an inreasing order