index match?

[Jing]

I have the following Table. The table does extend down for the full month. Now this table is duplicated vertically down the sheet for each rep (33 reps). What I am attempted to accomplish is to take the data from this sheet and organize it so that it has one rep per row having the dates extend horizontally. This way i can perform an easy vlookup on the name for the information, by date.

	A	B	C	D	E	F
2	Name</SPAN>	Agent ID</SPAN>	Agent Enterprise Name</SPAN>
3	Doe, Jon	523010</SPAN>	IPCC_CM1_PG1.Doe_Jon</SPAN>
4	Date</SPAN>	Calls Handled In (Inbound)</SPAN>	Avg Handle Time In (Inbound)</SPAN>	Avg Talk Time In (Inbound)</SPAN>	Avg Hold Time In (Inbound)</SPAN>	Avg Wrap Time In (Inbound)</SPAN>
5	1/1/2013</SPAN>	0</SPAN>	00:00</SPAN>	00:00</SPAN>	00:00</SPAN>	00:00</SPAN>
6	1/2/2013</SPAN>	0</SPAN>	00:00</SPAN>	00:00</SPAN>	00:00</SPAN>	00:00</SPAN>
7	1/3/2013</SPAN>	0</SPAN>	00:00</SPAN>	00:00</SPAN>	00:00</SPAN>	00:00</SPAN>
8	1/4/2013</SPAN>	0</SPAN>	00:00</SPAN>	00:00</SPAN>	00:00</SPAN>	00:00</SPAN>
9	1/5/2013</SPAN>	0</SPAN>	00:00</SPAN>	00:00</SPAN>	00:00</SPAN>	00:00</SPAN>
10	1/6/2013</SPAN>	0</SPAN>	00:00</SPAN>	00:00</SPAN>	00:00</SPAN>	00:00</SPAN>
11	1/7/2013</SPAN>	0</SPAN>	00:00</SPAN>	00:00</SPAN>	00:00</SPAN>	00:00</SPAN>
12	1/8/2013</SPAN>	0</SPAN>	00:00</SPAN>	00:00</SPAN>	00:00</SPAN>	00:00</SPAN>
13	1/9/2013</SPAN>	0</SPAN>	00:00</SPAN>	00:00</SPAN>	00:00</SPAN>	00:00</SPAN>
14	1/10/2013</SPAN>	0</SPAN>	00:00</SPAN>	00:00</SPAN>	00:00</SPAN>	00:00</SPAN>

<TBODY>
</TBODY>

End Result:

A

B

C

D

E

F

G

H

I

J

K

L

Calls Handled In (Inbound)

Date

2

ID's</SPAN>

Name</SPAN>

1/1/2013</SPAN>

1/2/2013</SPAN>

1/3/2013</SPAN>

1/4/2013</SPAN>

1/5/2013</SPAN>

1/6/2013</SPAN>

1/7/2013</SPAN>

1/8/2013</SPAN>

1/9/2013</SPAN>

1/10/2013</SPAN>

3

523010

Doe, Joe</SPAN>

<TBODY>
</TBODY>

Once i have the formula i will be able to modify it to accomidate the remaining columns from the first table.

Thank you

 

[Jing]

My appologies for multiple posts... my browser crashed twice trying to get this posted and i didn't realize it had been submitted successfully.

Thanks in advance for the help.

 

[Jing]

Bump