1111 Bob Salesman red 1/1/2007
1111 Bob Salesman blue 1/2/2007
2222 Mike Salesman red 1/1/2007
3333 Joe Manager green 8/24/2007
1111 Bob Salesman green 4/3/2007
2222 Mike Saleman green 6/1/2007
3333 Joe Manager red 5/31/2007
Basically, that's my data as it comes to me - the first column is the sale number. I need a trick that'll read the original data and then put everything for each unique sale number on a unique line in a new file by appending the date (Column E) and whatever is in column D to columns on the right in date order. So the end result would look like this:
1111 Bob Salesman red 1/1/2007 blue 1/2/2007 green 4/3/2007
2222 Mike Salesman red 1/1/2007 green 6/1/2007
3333 Joe Manager red 5/31/2007 green 8/24/2007
Anybody know how to do this?
1111 Bob Salesman blue 1/2/2007
2222 Mike Salesman red 1/1/2007
3333 Joe Manager green 8/24/2007
1111 Bob Salesman green 4/3/2007
2222 Mike Saleman green 6/1/2007
3333 Joe Manager red 5/31/2007
Basically, that's my data as it comes to me - the first column is the sale number. I need a trick that'll read the original data and then put everything for each unique sale number on a unique line in a new file by appending the date (Column E) and whatever is in column D to columns on the right in date order. So the end result would look like this:
1111 Bob Salesman red 1/1/2007 blue 1/2/2007 green 4/3/2007
2222 Mike Salesman red 1/1/2007 green 6/1/2007
3333 Joe Manager red 5/31/2007 green 8/24/2007
Anybody know how to do this?