Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have the following dataset:
A | B | C | D |
Blank | Blank | CX | DX |
Blank | Blank | CX2 | DX2 |
Name | BX1 | Data1 | Data3 |
Name2 | BX2 | Data2 | Data4 |
What I would like to achieve is the following:
A | B | C | D | E |
Name | BX1 | CX | CX2 | Data1 |
Name | BX1 | DX | DX2 | Data3 |
Name2 | BX2 | CX | CX2 | Data2 |
Name2 | BX2 | DX | DX2 | Data4 |
How could I achieve this in the simplest way?
Thank you!
Istvan
for name how you can map CX,CX2,DX and DX2..do they static??
Yes, let`s say they are.