i want data based on given match here my problem is
i have getting duplicates
i have applied formula like this below
i need output like this below
i have getting duplicates
i have applied formula like this below
Book1 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
2 | EMP NAME | ANIL | EMP NAME | AGE | CITY | MOBILE | ||||
3 | AGE | 25 | ANIL | 25 | HYDERABAD | 8521479632 | ||||
4 | CITY | HYDERABAD | ANIL | 25 | HYDERABAD | 8521479632 | ||||
5 | MOBILE | 8521479632 | ANIL | 25 | HYDERABAD | 8521479632 | ||||
6 | EMP NAME | SURESH | ANIL | 25 | HYDERABAD | 8521479632 | ||||
7 | AGE | 29 | ||||||||
8 | CITY | WARANGAL | ||||||||
9 | MOBILE | 7412589632 | ||||||||
10 | EMP NAME | ARJUN | ||||||||
11 | AGE | 30 | ||||||||
12 | CITY | HYDERABAD | ||||||||
13 | MOBILE | 9632147854 | ||||||||
14 | EMP NAME | BABU | ||||||||
15 | AGE | 32 | ||||||||
16 | CITY | VIZAG | ||||||||
17 | MOBILE | 4567893214 | ||||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
E3:H6 | E3 | =INDEX($B$2:$B$17,MATCH(E$2,$A$2:$A$17,0)) |
i need output like this below
Book1 | ||||||
---|---|---|---|---|---|---|
E | F | G | H | |||
2 | EMP NAME | AGE | CITY | MOBILE | ||
3 | ANIL | 25 | HYDERABAD | 8521479632 | ||
4 | SURESH | 29 | WARANGAL | 7412589632 | ||
5 | ARJUN | 30 | HYDERABAD | 9632147854 | ||
6 | BABU | 32 | VIZAG | 4567893214 | ||
Sheet1 |