+ Reply to Thread
Results 1 to 2 of 2

Merge rows with a few same columns in excel

  1. #1
    Registered User
    Join Date
    08-26-2011
    Location
    Mumbai
    MS-Off Ver
    Excel 2003
    Posts
    1

    Merge rows with a few same columns in excel

    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.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,168

    Re: Merge rows with a few same columns in excel

    Hi xparo and welcome to the forum,

    IMHO - don't put all the products a person owns in a single row. Excel likes the first format a lot better. What kind of report are you trying to achieve. Why do all products need to go i a single row?
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1