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