How to amalgamate 1000s of rows of data into a usable chart

C

chunt

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

ChrisM

In message (e-mail address removed),
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.
Click to expand...

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
 
Top