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!
