Hi!
I have data looking like this:
ID Category Value
1 S 3
1 M 2
2 S 1
2 M 4
I want to remove the value column and rather have one row for each value like this:
ID Category Value
1 S
1 S
1 S
1 M
1 M
2 S
2 M
2 M
2 M
2 M
Do anyone have any ideas on how to do this?
Would be very greatful for all help. Thank you!
Regards M