I have an excel sheet with data similar to the following
Reg_id Name Product_Owned Product_model
--------------------------------------------------------------------------------
34 Tom Laptop Dell Studio15
34 Tom Mobile HTC Sense
34 Tom Camera Canon xyz
67 Steven Laptop Apple Mac Book
67 Steven Phone Apple iPhone4
88 Sunny Mobile Samsung i9000
88 Sunny Camera Sony xyz
I have only three values in the Product_Owned column - Laptop, Camera & Mobile. I want their information to be stored as separate columns in a single row for the same person.
I want to make it in this format:
Reg_id Name Laptop Mobile Camera
-----------------------------------------------------------------------------------------------
34 Tom Dell Studio15 HTC Sense Canon xyz
67 Steven Apple Mac Book Apple iPhone4
88 Sunny Samsung i9000 Sony xyz
Can't do it manually as there are ~50000 rows. Any help will be appreciated.
Bookmarks