How to combin rows.

[Johnny]

anyone know how create like look at all columns and fnd text then combin that
row and put it in different column.
like this is what I need, but this only can do it in the same row:
=IF(D125="FISH",A1&","&B1&","&C1&","&D1&","&E1,"")

exsample: there are many rows that has (fish), I want to look at all columns
and find the rows has(fish), combin that row, and by order put it at column
M1,M2,M3....

 

[Don Guillett]

Look in the vba help index for FINDNEXT.

 

[Herbert Seidenberg]

Or use Advanced Filter...
Assume your data looks like this:
dat1 dat2 dat3 dat4 dat5 bin1 bin2 bin3 bin4 bin5
A S C E N
S A L M O fish
T R O U T fish
R C U L H
C A T F I fish
and you want to filter the rows that contain "fish".
Create this criteria:
bin1 bin2 bin3 bin4 bin5
fish
fish
fish
fish
fish
List Range: A1:J6 (all columns must have labels)
Criteria: A7:E12 (can be placed anywhere)
Copy to: M1 (or anyplace)
The result will look like this:
dat1 dat2 dat3 dat4 dat5
S A L M O
T R O U T
C A T F I
Concatenate as usual.