Need Formula Help

[Prasad K]

i want data based on given match here my problem is

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

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F	G	H
1
2	EMP NAME	ANIL			EMP NAME	AGE	CITY	MOBILE
3	AGE	25			ANIL	25	HYDERABAD	8521479632
4	CITY	HYDERABAD			SURESH	29	WARANGAL	7412589632
5	MOBILE	8521479632			ARJUN	30	HYDERABAD	9632147854
6	EMP NAME	SURESH			BABU	32	VIZAG	4567893214
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
18
Main

Cell Formulas
Range	Formula
E3:H8	E3	=IFERROR(INDEX($B$2:$B$17,AGGREGATE(15,6,(ROW($B$2:$B$17)-ROW($B$2)+1)/($A$2:$A$17=E$2),ROWS(E$3:E3))),"")

Not that you have a space after "Mobile" in A13 that you will need to remove

 

[Prasad K]

How about

Fluff.xlsm
	A	B	C	D	E	F	G	H
1
2	EMP NAME	ANIL			EMP NAME	AGE	CITY	MOBILE
3	AGE	25			ANIL	25	HYDERABAD	8521479632
4	CITY	HYDERABAD			SURESH	29	WARANGAL	7412589632
5	MOBILE	8521479632			ARJUN	30	HYDERABAD	9632147854
6	EMP NAME	SURESH			BABU	32	VIZAG	4567893214
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
18
Main

Cell Formulas
Range	Formula
E3:H8	E3	=IFERROR(INDEX($B$2:$B$17,AGGREGATE(15,6,(ROW($B$2:$B$17)-ROW($B$2)+1)/($A$2:$A$17=E$2),ROWS(E$3:E3))),"")

Not that you have a space after "Mobile" in A13 that you will need to remove

Thank you so much @Fluff Sir

 

[Fluff]

You're welcome & thanks for the feedback.