sarad agarwal
New Member
- Joined
- Mar 14, 2016
- Messages
- 20
Hi All,
I have data in this format:
What formula will give me this result?
I.e if all the cells for orange is blank in column b then result in column c should give me the concatenated value of the column a and the header of column b.
I have data in this format:
Auditor | Locale_DE |
Apple | |
Apple | Yes |
Apple | |
Orange | |
Orange | |
Orange | |
Grape | Yes |
Grape | |
Grape |
What formula will give me this result?
Auditor | Locale_DE | Required Value |
Apple | ||
Apple | Yes | |
Apple | ||
Orange | Orange_Locale_DE | |
Orange | Orange_Locale_DE | |
Orange | Orange_Locale_DE | |
Grape | Yes | |
Grape | ||
Grape | |
I.e if all the cells for orange is blank in column b then result in column c should give me the concatenated value of the column a and the header of column b.