V or H Look up where I can convert the Row info into Columns

[Mysstownsend]

I am working on a spreadsheet where I need to search for a name, then take the information that is below it (3 rows) and transfer it to another sheet and have the information show in columns.
For example:
example 1.JPG

Should turn to:
example 2.JPG

[alansidman]

Hi and welcome to the forum

Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome (manually entered is ok) and how you arrived at that. (Exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you. Also, not all members can upload picture files (Company firewalls, etc.)

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[FDibbins]

Agree with Alan on uploading a sample workbook.

However, take a look at using the INDEX/MATCH combo, you can add 3 to the row match. For more detailed advice, we await your workbook

[Mysstownsend]

Here is my sample

[FDibbins]

Thanks for the file.

Try this, copied across...
=INDEX(Data!$B:$B,MATCH($A2,Data!$B:$B,0)+COLUMN(Data!A$1))

Note that on Data Sheeet, Smith is spelt wrong

[AlKey]

Or this

in C1 and pull to the right to column F and down

=IF(MOD(ROW(A1),6)=1,INDEX($A1:$A$16,COLUMNS($C$1:C1)),"")

	A	B	C	D	E	F
1	Alex Keyser		Alex Keyser	2	3	Very nice
2	2
3	3
4	Very nice
5
6
7	Jason Bigs		Jason Bigs	1	2	Great job
8	1
9	2
10	Great job
11
12
13	Brendon Phelps		Brendon Phelps	10	8	I'd buy again
14	10
15	8
16	I'd buy again

[Mysstownsend]

You guys are awesome!!! I don't understand why you do this for free, but I'm thankful!!! Is there a way to make the results blank instead of "N/A" if a match is not found?

[AlKey]

You're welcome and thank you for the feedback!

To remove "NA" or any other errors just add IFERROR function to your formula

ex: =IFERROR(yourformula),""

Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).

[Mysstownsend]

I just did the most annoying and fun happy dance. Thank you!!!!!!

[FDibbins]

hahaha thanks for the kind words, it's responses like yours that make it worth while