Hello to all,
Please your help.
I have items that appear several times in column A and respective values in column B.
I want to show as headers from D1:G1 the values in column A and all the values for each element.
May you help me with a Excel formula to get this goal please.
<tbody>
</tbody>
Thanks in advance
Please your help.
I have items that appear several times in column A and respective values in column B.
I want to show as headers from D1:G1 the values in column A and all the values for each element.
May you help me with a Excel formula to get this goal please.
A | B | C | D | E | F | G | |
1 | BKL | 9 | BKL | LIN | BJU | TYP | |
2 | LIN | 1 | 9 | 1 | 2 | 8 | |
3 | BJU | 2 | 11 | 5 | 4 | 3 | |
4 | BJU | 4 | 7 | ||||
5 | BKL | 11 | |||||
6 | TYP | 8 | |||||
7 | LIN | 5 | |||||
8 | BKL | 7 | |||||
9 | TYP | 3 | |||||
10 |
<tbody>
</tbody>
Thanks in advance
Last edited: