Return Multiple Values With One Value

I have list of 2043 rows and i have like 29 values i need to look up and return me several values that associated with that particular number but I want it to list them horizontally or even vertically but whenever i get the right code in one cell and i drag that green box it formats it in a weird way that gives me an error.

Here is the sheet I would like an VBA or macro.... my VBA code is already on here but somehow i get an error.

Book3.xlsx

So what i did was the first code followed this example still get errors [URL] .....

So match pcode columnsA to find and return the columnB result somewhere else on the sheet list them out horizontally preferred or vertically.