+ Reply to Thread
Results 1 to 3 of 3

How to arrange 2nd column according to 1st column?

  1. #1
    Registered User
    Join Date
    02-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    54

    How to arrange 2nd column according to 1st column?

    In my excel file it's something like this

    Name Specification

    Product1 17"Screen
    Product1 128 RAM
    Product2 256 RAM
    Product2 Screen Protector
    Product1 40 GB Hard Disk
    Product1 121 Keys
    Product1 Intel Mouse
    Product2 15"Screen
    Product2 Charger
    Product2 Headphones
    Product1 15"Screen
    Product2 256 RAM
    Product3 Screen Protector
    Product4 Charger
    Product5 Headphones

    ......and so on....for 1000's of products....

    I want to arrange all the Specifications according to the products
    like this:

    Product1 15"Screen
    ............ 256 RAM
    ............ Screen Protector
    ............ Charger
    ............ Headphones


    Product2 17"Screen
    ............ 128 RAM
    ............ Screen Protector
    ............ Charger
    ............ Headphones

    PLEASE EXPLAIN ME WHAT TO DO STEP BY STEP
    PLEASE HELP...It's really URGENT...
    Last edited by ASP__DEVELOPER; 02-09-2010 at 11:34 PM.

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,375

    Re: How to arrange 2nd column according to 1st column? PLEASE HELP URGENT

    Hi and welcome to the forum

    Are we talking one column or two?

    You can click the column(s), then go Data - Sort and sort ascending by column A, if you have two columns you may want to specify that column B sorts ascending, too.

  3. #3
    Registered User
    Join Date
    02-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    54

    Re: How to arrange 2nd column according to 1st column? PLEASE HELP URGENT

    Thanks a lot for the warm welcome....
    ok talking about problem i have 2 columns
    1st Columns is Name, 2nd is Specifications

    now 1 more questions

    lets say my data in 2 columns is like this:
    Please Login or Register  to view this content.
    ......and so on....for 1000's of products....

    NOW i want to convert this data into something like this:

    Product1 15"Screen
    ............ 256 RAM
    ............ Screen Protector
    ............ Charger
    ............ Headphones


    Product2 17"Screen
    ............ 128 RAM
    ............ Screen Protector
    ............ Charger
    ............ Headphones


    BUT BUT BUT BUT....


    I want to have all the specifications related to each product in 1 cell only
    like :
    Product1 is in left column in 1 cell
    Its specifications are in the 2nd column in 1 CELL
    and at the same time i want to add </br> in between all the specifications like this

    Product1 17"Screen</br>
    ............ 128 RAM</br>
    ............ Screen Protector</br>
    ............ Charger</br>
    ............ Headphones</br>

    All Specifications in 1 cell related to each product along with the </br> added after each specification...?????


    PLEASE HELP ME...
    Last edited by shg; 02-10-2010 at 01:07 AM.

+ 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