D1:
12345

E1:
=IF(ISERROR(INDEX($A$1:$B$8,SMALL(IF($A$1:$A$8=$D$ 1,ROW($A$1:$A$8)),ROW(1:1)),2)),"",INDEX($A$1:$B$8 ,SMALL(IF($A$1:$A$8=$D$1,ROW($A$1:$A$8)),ROW(1:1)) ,2))

Commit this function with Ctrl + Shift + Enter

Hope this gives you what you need...

"Igneshwara reddy" wrote:

Hi,

I have two columns in the sheet and the data in the A & B column:
Column A has few store numbers and column B has the store number data
A B
12345 sjfdiasdhfajpfjaofoafoafvoa
12345 ikgiureingflsdnonolsn
12345 fiueshoifjowejfpweoefawjf
45678 sdfsmnfswfofoinionsio
45678 rgsfejfpjwejfpewjpfjwp
45678 gremgoperokpgkerpgpermgpomp
45678 ngofjosijfjwsfjpofpfp
45678 ofojosnfosnofnosfjpspjmps

I will do the Advanced filter and take the unique records from the Column A
to Column C. The data according to the store number in column A & column B
should sit in the D column in one cell for the entire store number of column
C.

Let me know if it can work with the concatenate function or vlookup or
parenthesis has to be used to get the results.

Do the needful at the earliest.

Regards,
Igneshwara reddy