I have the same names say "Peter" appearing in column B starting at B3 down
long way and the number of rows for which the same name would repeat is
unpredictable as it may vary from time to time.i want to write this inside a
macro or whichever is effective
Now i have sorted and brought all teh Peter names into consecutive rows in
col B
how do i make it as one Peter. i don want to deleet teh rows corresponding
to peter,

Only column B should have one entry for Peter and col C will ahve teh
different values againstthis one Peter.
like Peter I wil ahev any number of names like
Peter read
Peter write
Peter read
Peter start
bob write
bob sit
bob draw
etc..
...
...

I need to make it as
Peter read
write
read
start
Bob write
sit
draw

If the data is sorted by name, then assuming you have a header row
insert a new column B and put this formula in B2:

=IF(A2=A1,"",A2)

then copy this down column B. You can hide column A if you want it to
look the same as your example.

Hope this helps.

Pete

On Feb 21, 12:36*pm, deepika :excel help
wrote:
I have the same names say "Peter" appearing in column B starting at B3 down
long way and the number of *rows for which the same name would repeat is
unpredictable as it may vary from time to time.i want to write this inside *a
macro or whichever is effective
Now i have sorted and brought all teh Peter names into consecutive rows in
col B
how do i make it as one Peter. i don want to deleet teh rows corresponding
to peter,

Only column B should have one entry for Peter and col C will ahve teh
different values againstthis one Peter.
like Peter I wil ahev any number of names like
Peter * *read
Peter * *write
Peter * *read
Peter * *start
bob * * *write
bob * * *sit
bob * * *draw
etc..
..
..

I need to make it as
Peter * *read
* * * * * * write
* * * * * * read
* * * * * *start
Bob * * *write
* * * * * *sit
* * * * * *draw

One way to consider is this.

Select all your names and ensuring B3 is the active (Highlighted) cell then

Format|Conditional formatting|Formula is
=B3=B2

Then select a font colour the same as your background and click OK
The names will still be there but you won't see them

Mike

"deepika :excel help" wrote:

I have the same names say "Peter" appearing in column B starting at B3 down
long way and the number of rows for which the same name would repeat is
unpredictable as it may vary from time to time.i want to write this inside a
macro or whichever is effective
Now i have sorted and brought all teh Peter names into consecutive rows in
col B
how do i make it as one Peter. i don want to deleet teh rows corresponding
to peter,

Only column B should have one entry for Peter and col C will ahve teh
different values againstthis one Peter.
like Peter I wil ahev any number of names like
Peter read
Peter write
Peter read
Peter start
bob write
bob sit
bob draw
etc..
..
..

I need to make it as
Peter read
write
read
start
Bob write
sit
draw

Also, you should keep in mind that removing names will also remove your
ability to sort by name..
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"deepika :excel help"
wrote in message
I have the same names say "Peter" appearing in column B starting at B3 down
long way and the number of rows for which the same name would repeat is
unpredictable as it may vary from time to time.i want to write this inside a
macro or whichever is effective
Now i have sorted and brought all teh Peter names into consecutive rows in
col B
how do i make it as one Peter. i don want to deleet teh rows corresponding
to peter,

Only column B should have one entry for Peter and col C will ahve teh
different values againstthis one Peter.
like Peter I wil ahev any number of names like
Peter read
Peter write
Peter read
Peter start
bob write
bob sit
bob draw
etc..

I need to make it as
Peter read
write
read
start
Bob write
sit
draw