hi all need some help please.
in column 'A' I have a list of numbers with multiple duplicates. in column 'b' I have a list of names, in column 'c' I have a list of colours.
<colgroup><col width="72" style="width: 54pt;" span="3">
<tbody>
</tbody>
what I would like to do in column 'D & E' is to have these values next to each other so 'a1' would stay the same (1) and 'd1' would say yellow & 'E1' would say red.
<colgroup><col width="72" style="width: 54pt;" span="5">
<tbody>
</tbody>
any help would be appreciated.
Steve
in column 'A' I have a list of numbers with multiple duplicates. in column 'b' I have a list of names, in column 'c' I have a list of colours.
A | B | C |
1 | dave | yellow |
1 | dave | red |
2 | paul | yellow |
2 | paul | green |
3 | mark | red |
3 | mark | red |
what I would like to do in column 'D & E' is to have these values next to each other so 'a1' would stay the same (1) and 'd1' would say yellow & 'E1' would say red.
A | B | C | D | E |
1 | dave | yellow | YELLOW | RED |
2 | paul | yellow | YELLOW | GREEN |
3 | mark | red | RED | RED |
any help would be appreciated.
Steve
Last edited: