I have the following dataset
where curr. type 82 is always EUR and curr. type 10 may vary :
I want to transpose the dataset so that the amount and the curr. for the rows where curr. type = 10 are transposed to 2 new columns as such :
Could I achieve this with the pivo "Rows to Columns" function ?
I am not sure how to use it.
2 answers
I would (unless there's a mitigating reason that's not been conveyed here) simply select Curr Type 10 in the upper pane, then click Keep Only:
No need to transpose. Then rename the columns as desired.
Best, Don
(Please, don't forget to click Select as Best or Upvote !)
