Converting 2 Columns With Repeating Info Into Another Worksheet In Horizontal Format

taking a spreadsheet that has vertical repeating info in Column A and results in Column B and converting that to another sheet in a horizontal list. The main problem is that the repeating info in Column A may or may not always be the same for every customer; therefore, when it is placed in a horizontal format some cells may or may not have results. I tried a arbitrary lookup. Here is the formula I used:

{=INDEX(INFO!$A$1:$B$300, SMALL(IF($A$1=INFO!$A$1:$A$300, ROW(INFO!$A$1:$A$300)-MIN(ROW(INFO!$A$1:$A$300))+1, ""), ROW(B1)),COLUMN(B1))}

That got me started. I am willing to use a macro. Here is some sample data:

Table 1 has a sample of the info:
IDENTIFIER
CUSTOMER INFO
2000
111111

[Code].....