Inquiry

[Duwin]

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.)

 

[Rick Rothstein]

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.

 

[Duwin]

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.)

 

[Duwin]

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.)

Thanks in advance

 

[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)),"")

 

[Duwin]

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

 

[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.

 

[Duwin]

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 ?

 

[jasonb75]

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))),"")

 

[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