Thread: 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...

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.

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:

Code:

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....

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...