Formatting Data in Excel

[quig699]

Hi,

I was looking for an efficient way of convering data in excel that looks like this

Bob Smith
Calls Talk Work Total ATT AWT


Monday 10/21/13 50 16827 7719 24546 337 154
Tuesday 10/22/13 59 18199 9405 27604 308 159
Wednesday10/23/13 57 19500 8206 27706 342 144
Thursday 10/24/13 55 18187 7870 26057 331 143
Friday 10/25/13 29 10458 15725 26183 361 542

Total 250 83171 48925 132096

Average 50 16634 9785 26419 333 196
(The data repeats for each team member. The number of days change based on the days the agent wored)

Into data that looks like this


Bob Smith John Smith Jill Jones
Calls 50 52 67
ATT 337 265 319
AWT 154 129 197

I need a way to pull specific days or the total for the week. Any suggestions?

Thank You!!!


Thanks,

Amy

 

[SkipVought]

hi,

Excel is designed to work with tabular data. faq68-5184

What you have is a report: an AWFUL CURSED structure to have to work in.

You need to get your data into a proper table, from which all sorts of good and wonderful analysis and reporting can be done quite simply using the treaurehouse of Excel features.

I see 8 columns of data but I do not see 8 HEADINGS!

Assumning that each column has a heading (IMPORTANT), I'd

1. insert a column to the left of your data for the NAME, so that you data might look something like this...
[pre]
name day date Calls Talk Work Total ATT AWT
Bob Smith Mon 10/21/2013 50 16827 7719 24546 337 154
Bob Smith Tue 10/22/2013 59 18199 9405 27604 308 159
Bob Smith Wed 10/23/2013 57 19500 8206 27706 342 144
Bob Smith Thu 10/24/2013 55 18187 7870 26057 331 143
Bob Smith Fri 10/25/2013 29 10458 15725 26183 361 542
[/pre]

Once your data is in this format, a simple PivotTable can summarize your data in all kinds of amazing ways in a matter of mere seconds!

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]