View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Ken Wright
 
Posts: n/a
Default duplicate the each row twice in one worksheet

Select the whole lot, copy and then paste at the bottom of your data.
Repeat then sort on name.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"L.J." wrote in message
...
I have 89 rows data (first name, last name) in one worksheet, for some
reason I need to repeat their name 3 times for some reasons.
Is there any easy way to do so wihtout running copy 3 times of 89 rows.
Any tip would be much appreciated.

Regards,
MH