Combination of multiple Columns

[udprocks]

Dear All,

Can anyone please help me out with it,,,,

need to combine multiple columns in one column..

 

[Asheesh]

hi mate...

Try this

INDEX($A$2:$D$9,MOD(ROW()-2,COUNTA($A:$A)-1)+1,(INT((ROW()-1)/COUNTA($A:$A)))+1)

 

[Asheesh]

Hi Jitendra - please use the below one...there was a minor correction required..

INDEX($A$2:$D$9,MOD(ROW()-2,COUNTA($A:$A)-1)+1,INT((ROW()-2)/(COUNTA(A:A)-1))+1)

 

[Mike H..]

Dear All,

Can anyone please help me out with it,,,,

need to combine multiple columns in one column..

And just for the exercise here's one that does it rowwise into a single column.

=INDEX($A$2:$D$9,1+INT((ROW(A1)-1)/COLUMNS($A$2:$D$9)),MOD(ROW(A1)-1+COLUMNS($A$2:$D$9),COLUMNS($A$2:$D$9))+1)

 

[udprocks]

And just for the exercise here's one that does it rowwise into a single column.

=INDEX($A$2:$D$9,1+INT((ROW(A1)-1)/COLUMNS($A$2:$D$9)),MOD(ROW(A1)-1+COLUMNS($A$2:$D$9),COLUMNS($A$2:$D$9))+1)

Hi Mike,

Your Formula works,

thank you for support,

dear ashis ,

with ur formula i am not getting exact result when i am applying this in my main file..

its capturing only few numbers not all.

 

[Asheesh]

Hi Jitendra,

Please see the attached...It is working absolutely fine here...

Note: Please ignore the formula in comment number 2..

 

[udprocks]

Hi Jitendra,

Please see the attached...It is working absolutely fine here...

Note: Please ignore the formula in comment number 2..

Hi Ashish,

Please see the difference with both formulas i have exact result with mike formula but , i think i m missing something in ur formula, look once with my exact file...

 

[Asheesh]

both formulas are different...I wrote this formula as per the requirement explained in the initial attachment...anyway all is well that ends well.., Mike is a champ anyway...

 

[udprocks]

both formulas are different...I wrote this formula as per the requirement explained in the initial attachment...anyway all is well that ends well.., Mike is a champ anyway...

Yes Ashish , if end is well then all is well...

but also thank u for efforts...