Duplicating Values AND Dates

  • Thread starter Thread starter Deb
  • Start date Start date
D

Deb

Tom? Chuck? Anyone else?

O.K... You showed me how to duplicate the date. Can you
show me how to duplicate the date AND a value that is
attached?(2 columns)

From this:
10/1/2001 23.1
10/2/2001 22.4
10/3/2001 21.5
10/4/2001 21.0
10/5/2001 20.6
10/6/2001 20.7
10/7/2001 20.7
10/8/2001 20.7
10/9/2001 21.2
10/10/2001 21.8
10/11/2001 49.1
10/12/2001 58.8

To this:
10/1/2001 23.1
10/1/2001 23.1
10/2/2001 22.4
10/2/2001 22.4
10/3/2001 21.5
10/3/2001 21.5
10/4/2001 21.0
10/4/2001 21.0
 
How about just copying the range and pasting it below the existing range.

Then sort by that first column.
 
Back
Top