Possible Vlookup: Multi Criteria without using Unique Variables

[KuraiChikara]

Hello,
I'm trying to see if there is a way to pull different types of data from criteria that can be repeated; Example:
1: There are only 2 people in the name criteria but they are listed more than once (Jane Doe twice and John Doe 4x)
2: I'm looking to do a formula that will remove the duplicate names while allowing me to find each possible item under their name WITHOUT adding unique variables (IE: Jane Doe 1, Jane Doe 2, etc) if that's even possible

Name (criteria)	Item
Jane Doe	Strawberries
Jane Doe	Raspberries
John Doe	Pineapples
John Doe	Blueberries
John Doe	Apples
John Doe	Grapefruit

GOAL:

Name	Item 1 (formula)	Item 2 (formula)	Item 3 (formula)	Item 4 (formula)
Jane Doe	Strawberries	Raspberries
John Doe	Pineapple	Blueberries	Apples	Grapefruit

 

[Fluff]

What version of XL are you using? Please amend you account details to show this & what platform you are using. It enables members to suggest a solution that should work. Thanks

 

[KuraiChikara]

Office Professional Plus 2013

 

[Fluff]

Thanks for that.
How about

+Fluff.xlsm
	A	B
1	Name (criteria)	Item
2	Jane Doe	Strawberries
3	Jane Doe	Raspberries
4	John Doe	Pineapples
5	John Doe	Blueberries
6	John Doe	Apples
7	John Doe	Grapefruit
Sheet1

+Fluff.xlsm
	A	B	C	D	E	F	G	H	I
1	Name	Item 1	Item 2	Item 3	Item 4	Item 5	Item 6	Item 7	Item 8
2	Jane Doe	Strawberries	Raspberries
3	John Doe	Pineapples	Blueberries	Apples	Grapefruit
4
5
6
7
8
Sheet2

Cell Formulas
Range	Formula
A2:A5	A2	=IFERROR(INDEX(Sheet1!$A$2:$A$7,MATCH(0,INDEX(COUNTIF(A$1:A1,Sheet1!$A$2:$A$7),0),0)),"")
B2:I5	B2	=IFERROR(INDEX(Sheet1!$B$2:$B$7,AGGREGATE(15,6,(ROW(Sheet1!$B$2:$B$7)-ROW(Sheet1!$B$2)+1)/(Sheet1!$A$2:$A$7=$A2),COLUMNS($A2:A2))),"")

 

[KuraiChikara]

This works. Thank you very much

 

[Fluff]

You're welcome & thanks for the feedback