Hi guys,
I'm trying to build a concatenation for each line (group 1, group 2, group 3,...) based on the values each line has.
For example, for Group 1 line, if a cell value is not blank then i wish to concatenate the country and category for that column. So for Group the concatenation should be PT1100. For Group 2 line, it should be PT1101 + ES1100 + ES1101 and for Group 3 line it should be PT1100 + ES1101
Can it be done? Thx in advance for any help.
I'm trying to build a concatenation for each line (group 1, group 2, group 3,...) based on the values each line has.
For example, for Group 1 line, if a cell value is not blank then i wish to concatenate the country and category for that column. So for Group the concatenation should be PT1100. For Group 2 line, it should be PT1101 + ES1100 + ES1101 and for Group 3 line it should be PT1100 + ES1101
Country --> | PT | PT | ES | ES | |
Category --> | 1100 Cat 1 | 1101 Cat 2 | 1100 Cat 1 | 1101 Cat 2 | Concatenation |
Group 1 | 100 | -1 | PT1100 | ||
Group 2 | 20 | 20 | 23 | PT1101 + ES1100 + ES1101 | |
Group 3 | 30 | 21 | PT1100 + ES1101 | ||
Group 4 |
Can it be done? Thx in advance for any help.