# Urgent Solution Req

#### sushantrao

##### Board Regular
Hi All,

I Have Data in the below format
calllogreport 20 sept.xls
BCDE
2X-INQUIRY1
3AARTITotal1
4B-BLANK CALL15
5X-INQUIRY2
6DIPIKATotal17
7B-BLANK CALL2
8EKTATotal2
9X-INQUIRY6
10AARTITotal6
11X-INQUIRY1
12CALL CENTER TEST TICKETTotal1
13X-INQUIRY14
14DIPIKATotal14
15X-INQUIRY1
16EKTATotal1
Sheet4

which in want in the below format
calllogreport 20 sept.xls
FGHIJK
1
2X-INQUIRYB-BLANK CALLCOMPLAINT
3AARTI7
4DIPIKA1615
5EKTA32
6
7
Sheet4

I have data in 400 Rows where i cannot use the same formula
i tried lookup but not worked. i copy paste the name of the agent againts
his complaint, blank call & comalaint call & then use filter but I have 20 days data & each day has 400 rows with the data
can any one help gor any other formula or solution ?
Its urgent

thanks,
Sushant

### Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Replies
3
Views
114
Replies
3
Views
40
Replies
6
Views
70
Replies
4
Views
61
Replies
4
Views
55

1,109,380
Messages
5,528,357
Members
409,817
Latest member
JiNXX9500

### This Week's Hot Topics

• Change military grades into rank
Afternoon all Need help with formula that will change military rank (i.e. 1, 2, 3 into Amn, A1C, SrA). Running IF formula that does not work...
• VBA COUNTIF SOLUTION
Hi The following are the errors spread across the several columns from E to Q ie. 13 columns across several sheets with more than 500 rows per...
• INSERT ROW WITH SPECIFIS TEXT IN A COLUMN
Hi All! How can identify that that the row to be inserted has to be inserted before 1st row with specific text in column F. If I record the...