Columns to rows between sheets with criteria

[Dichotmist]

I need some help with building a macro. I am looking to have it copy the selected text in a column in one sheet and move it to a row in another sheet. But it needs to have some criteria. In the Marks sheet there are two columns that I need to use: ItemID and Text. The ItemID is the criteria and the Text is the data that needs to be moved. The ItemID is 16 through 24. For example ItemID 16 is the Text First Name. The macro needs to copy First Name to the List Sheet first row first column. ItemID 21 is the Rank/Prefix and needs to be copied to the first row second column and so on. Then the next ItemID that equals 16 needs to be copies to the second row. Hopefully that makes sense and any help you can give me would be greatly appreciated.
Thanks

[mdbct]

Macro assumes the following:
There is a sheet called List.
The 9 categories on the Marks sheet are the only possible categories

Please Login or Register  to view this content.

See attached.

[Dichotmist]

Perfect! Thanks mdbct!

[Dichotmist]

I guess I have another question on this. I ran into a problem where the ItemID of 16 may not be the first in the group. How would I implement criteria to verify that GuestID has changed before changing rows?
Thanks again for your help!