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

 

[jasonb75]

In that case either something must have been changed, or it is not as you describe.

edit:-

Reading your posts again, there appears to be some contradicting use of row and column in your descriptions, perhaps this variation will work.

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

 

[Rick Rothstein]

*it will transfer all values starting with the non zero value(in my example it must start with 2 etc.)

I know your data can start with 0 values in the beginning cells, but could there ever be a 0 value in a cell somewhere down in the middle of your values after the first non-zero value?

 

[Duwin]

I know your data can start with 0 values in the beginning cells, but could there ever be a 0 value in a cell somewhere down in the middle of your values after the first non-zero value?

Yes rick there are zeros between the first non zero cell snd the last cell..i need to tramsfer the first non zero cell up to the last cell in same order

 

[Duwin]

In that case either something must have been changed, or it is not as you describe.

edit:-

Reading your posts again, there appears to be some contradicting use of row and column in your descriptions, perhaps this variation will work.

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

Ok i will try this..thank you very much jason for your help