Placing multiple values in cells of a row based on value of cell in a column

Screen Shot 2015-07-10 at 10.52.03 AM.png

Can anyone tell me how to move these values from multiple cells in a column (Column B) to a single row based on one cells value (Column A)?
Thank you in advance

The formula answer:

1) Highlight column A
2) Use Data > Advanced Filter
- Unique Values Only
- Copy To Another Location (Select D1)

This gives you an extracted list of all your street names.

3) Enter this formula in E2, then copy across and down as far as needed:

=IF(COLUMN(A1)>COUNTIF($A:$A, $D2), "", INDEX($B:$B, MATCH($D2,$A:$A, 0) + COLUMN(A1)-1))

A straight formula method that may help you:
These are ARRAY formulae that are entered with Ctrl + Shift + Enter

To get a unique listing of the streets in column D enter the following formula in D2 and fill down:

Formula:

Please Login or Register  to view this content.

To get the entries for each street, enter this formula in E2 and fill Across and Down:

Formula:

Please Login or Register  to view this content.

Remember: These are ARRAY formulae to be entered with Ctrl + Shift + Enter.

Result:

	A	B	C	D	E	F	G	H	I	J	K
1	Street	Grid		Street	Grid1	Grid2	Grid3	Grid4	Grid5	Grid6	Grid7
2	Pike St	201		Pike St	201	205
3	Pike St	205		Johns St	201	204	207
4	Johns St	201		Smith St	200
5	Johns St	204		Main St	102	106	107	108	110	111
6	Johns St	207
7	Smith St	200
8	Main St	102
9	Main St	106
10	Main St	107
11	Main St	108
12	Main St	110
13	Main St	111

Yes, you're correct, the formula should have been entered in E2, next to the first street name. My apologies.