I have the following data in colums A - D with the headings below.
(There are 1000s of rows of data, but only the 4 columns)

PhoneNumber_____Status____________________BillableTime_____Transfers
9588_____________Delivered to Answ Mach_____15_____________
0060_____________Delivered to Answ Mach_____23_____________
2024_____________No Answer________________0______________
2024_____________No Answer________________0______________
2024_____________No Answer________________0______________
3868_____________Delivered to Answ Mach_____35_____________
2342_____________Delivered to Voice__________1204___________YES
2342_____________No Answer________________0______________
4548_____________Delivered to Answ Mach_____36_____________
1079_____________No Answer________________0______________
1079_____________No Answer________________0______________
1079_____________Delivered to Answ Mach_____33_____________
6767_____________Delivered to Voice__________49_____________
2001_____________Delivered to Answ Mach_____17_____________
7912_____________Delivered to Answ Mach_____16_____________
8641_____________No Answer________________0______________
8641_____________Delivered to Answ Mach_____46_____________

I need to find a way (maybe a pivot table, I don't know) so that each
phone number is listed only once, in a first coumn, and then how ever
many status match to that phone number are listed in the next colums
across - 1 column per listing of that phone number - and then the
total billable time and then if there was a transfer. Hopefully with
new headings as seen below.

i.e. the above iformation would look like:

PhoneNumber_____Attempt #1_____Attempt #2____Attempt
#3______TotalBillableTime_____Transfers
..
..
..
2342____________No Answer_____Delivered to
Voice_____BLANK____1204_____Yes
..
..
..

I just took one example from the first table. Phone numbers can have
1 or more attempts and so I need to be able to easily see how many
attermps there were pere number (ie. what the result was for every
attempt), how long it was, and whether there was an attempt or not.
There might be also be more than one row for a particular phone number
that contain billable time, so I need a total billable time in the
final result table.

I hope that this makes sense, and that someone can help me with this.
I'd be hugely grateful.

Thanks a lot

Chris.

In message (E-Mail Removed),
(E-Mail Removed) <(E-Mail Removed)> Proclaimed from the tallest tower:

> I have the following data in colums A - D with the headings below.
> (There are 1000s of rows of data, but only the 4 columns)
>
> PhoneNumber_____Status____________________BillableTime_____Transfers
> 9588_____________Delivered to Answ Mach_____15_____________
> 0060_____________Delivered to Answ Mach_____23_____________
> 2024_____________No Answer________________0______________
> 2024_____________No Answer________________0______________
> 2024_____________No Answer________________0______________
> 3868_____________Delivered to Answ Mach_____35_____________
> 2342_____________Delivered to Voice__________1204___________YES
> 2342_____________No Answer________________0______________
> 4548_____________Delivered to Answ Mach_____36_____________
> 1079_____________No Answer________________0______________
> 1079_____________No Answer________________0______________
> 1079_____________Delivered to Answ Mach_____33_____________
> 6767_____________Delivered to Voice__________49_____________
> 2001_____________Delivered to Answ Mach_____17_____________
> 7912_____________Delivered to Answ Mach_____16_____________
> 8641_____________No Answer________________0______________
> 8641_____________Delivered to Answ Mach_____46_____________
>
> I need to find a way (maybe a pivot table, I don't know) so that each
> phone number is listed only once, in a first coumn, and then how ever
> many status match to that phone number are listed in the next colums
> across - 1 column per listing of that phone number - and then the
> total billable time and then if there was a transfer. Hopefully with
> new headings as seen below.
>
> i.e. the above iformation would look like:
>
> PhoneNumber_____Attempt #1_____Attempt #2____Attempt
> #3______TotalBillableTime_____Transfers
> .
> .
> .
> 2342____________No Answer_____Delivered to
> Voice_____BLANK____1204_____Yes
> .
> .
> .
>
> I just took one example from the first table. Phone numbers can have
> 1 or more attempts and so I need to be able to easily see how many
> attermps there were pere number (ie. what the result was for every
> attempt), how long it was, and whether there was an attempt or not.
> There might be also be more than one row for a particular phone number
> that contain billable time, so I need a total billable time in the
> final result table.
>
> I hope that this makes sense, and that someone can help me with this.
> I'd be hugely grateful.
>
> Thanks a lot
>
> Chris.

So do you only ever make three attempts, or could it sometime be four or
more?
A pivot table is quite probably the way to go though anyway...

Not sure what 'Transfers' means in this context though

--
Regards,
Chris.
(Remove Elvis's shoes to email me)