bb19august
New Member
- Joined
- Feb 1, 2019
- Messages
- 18
Car | Bus | Train | Result |
1 | 1 | Car, Bus | |
2 | 2 | Bus, Train | |
1 | No | Car, Train | |
7 | 3 | Car, Bus | |
10 | Yes | Car, Train |
<tbody>
</tbody>
Request your help to have a formula in excel to get a result as shown above. Cells could have numbers or blanks or text. if there is any number/text in any cell(s)the header(s) has to copied and concatenated and separated by comma.