shumonsaha
Board Regular
- Joined
- Mar 22, 2009
- Messages
- 56
I have data in two columns
Column A has values with names like -
John, Paul, Hena, Kumar, Paul, Hena, John in different rows
Colum B has day values - eg , sun, mon, tue, wed , thu, fri and sat
I want to insert a new column C with formula that returns
1. for every John, concatenate of all the day values adjacent to row of John eg "sunmonfri"
Similarly for all the values in Column A, Column C should reflect the concatenate values of Column B.
Please help
Column A has values with names like -
John, Paul, Hena, Kumar, Paul, Hena, John in different rows
Colum B has day values - eg , sun, mon, tue, wed , thu, fri and sat
I want to insert a new column C with formula that returns
1. for every John, concatenate of all the day values adjacent to row of John eg "sunmonfri"
Similarly for all the values in Column A, Column C should reflect the concatenate values of Column B.
Please help