Hello,
I want to prepare my data for advanced analytic and need to transform my data but could not find a solution yet.
Data looks like:
UserID | Test | Value | Unit |
1 | A | 3.0 | dl |
1 | B | 2.0 | cm |
2 | A | 1.0 | dl |
Results should look like this:
UserID | Test A Value | Test A Unit | Test B Value | Test B Unit |
1 | 3.0 | dl | 2.0 | cm |
2 | 1.0 | dl |
Solved! Go to Solution.
Thanks a lot, this solved it perfectly!