Excel: Convert rows to columns and sort by ID

Closed
ana35 - Mar 31, 2010 at 10:28 AM
 Blocked Profile - Apr 2, 2010 at 04:49 AM
Hi,

I have an Excel sheet with the data in this order:

A B C D
date1 / text1 / amount1 / ID1
date2 / text2 / amount2 / ID1
date3 / text3 / amount3 / ID2
.
.
.
date n / text n / amount n / ID n


I sometimes have many rows with the same ID (column D) but different values for the columns A, B and C. I would like to get rows with:

A B C ...
ID1/ date1 / text1 / amount1 / ... / date n / text n / amount n
ID2/ date3 / text3 / amount3 / ... / date m / text m / amount m
etc.

Example:

3/10/2000 / aa / $2 / 1111
5/8/1998 / bbb / $5 / 1111
1/9/2002 / ccc / $1 / 2222
4/7/1997 / ddd / $3 / 2222
converted to:

1111 / 3/10/2000 / aa / $2 / 5/8/1998 / bbb / $5
2222 / 1/9/2002 / ccc / $1 / 4/7/1997 / ddd / $3

It's quite an emergency...
Thank you!

1 reply

Blocked Profile
Apr 2, 2010 at 04:49 AM
Hello Sir,

To get an idea of solving this please check here:

https://ccm.net/faq/6651-excel-change-row-color-on-condition

Thanks
0