Do you have a header row e.g. Store_name and Data in row 1 ?. Also, is
your data sorted by store name, or if not then could it be? If the
answer to both questions is yes, then you can do the following:

In C2 enter this formula and copy down:

=IF(A2=A3,"",A2)

This will give you the store number only for the last row of each
block of store numbers. In D2 enter this formula and copy down:

=IF(A2=A1,D1&B2,B2)

This will append the data from column B for contiguous blocks of store
numbers - for each new store number it will start again.

Then highlight columns C and D, click <copy then Edit | Paste Special
| Values (check) | OK then <Enter. Copy the headings from A1:B1 into
C1:D1.

Now choose Data | Filter | Autofilter (check) and from the filter pull-
down on column C select <blanks. Highlight all the visible rows
(excluding the header row) and Edit | Delete Row. Select All from the
filter pull-down on column C, then remove the filters by Data | Filter
| Autofilter (uncheck).

Finally, delete columns A and B, and you should end up with what you
want.

Hope this helps.

Pete


On Aug 29, 4:54 pm, 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