I have a dataset of policies that sometimes have multiple IDs associated with them. Instead of having multiple rows for each policy I want to add additional columns to store that information side by side. How would I go about doing this? Current Dataset Example: Policy ID Percent 12345 12 5% 12345 15 5% 2346 23 6% 2346 24 7% 15678 30 5% Goal Dataset Example: Policy ID1 Percent1 ID2 Percent2 12345 12 5% 15 5% 2346 23 6% 24 7% 15678 30 5%
... View more