How to combin rows.

  • Thread starter Thread starter Johnny
  • Start date Start date
J

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....
 
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.
 
Back
Top