Urgent help needed!

[GrossNole]

Here is an example of what I want to do.
This is what the data would look like:

DATE RATE1 DATE RATE2 DATE RATE3
1/06__ 3___ 1/06__ 4___ 1/06__ 5
2/06__ 4___ 3/06__ 5___ 2/06__ 6
3/06__ 5___ 4/06__ 6___ 3/06__ 7
5/06__ 6___ 5/06__ 7___ 4/06__ 8

As you can see some of the dates are missing in certain columns so I am trying to figure out how to line up each row with the same date so it would look like this:

DATE RATE1 DATE RATE2 DATE RATE3
1/06__ 3___ 1/06__ 4___ 1/06__ 5
2/06__ 4______________ 2/06__ 6
3/06__ 5___ 3/06__ 5___ 3/06__ 7
___________4/06__ 6___ 4/06__ 8
5/06__ 6___ 5/06__ 7

Once I finish this I want to graph (using Scatter graph with Smooth lines) this data all on one graph showing the relationship between the three.

Thanks again for your help.

 

[jbeaucaire]

How about this:

Option Explicit

Sub ReAlign()
'JBeaucaire  (9/11/2009)
Dim i As Long:  i = 2
Dim Minm As Long

    Do
        Minm = WorksheetFunction.Min(Cells(i, "A"), Cells(i, "C"), Cells(i, "E"))
        If Cells(i, "A") > Minm Then Range(Cells(i, "A"), Cells(i, "B")).Insert xlShiftDown
        If Cells(i, "C") > Minm Then Range(Cells(i, "C"), Cells(i, "D")).Insert xlShiftDown
        If Cells(i, "E") > Minm Then Range(Cells(i, "E"), Cells(i, "F")).Insert xlShiftDown
        i = i + 1
    Loop Until Evaluate("=COUNT(A" & i & ":F" & i & ")=0")

End Sub

Excel Workbook
	A	B	C	D	E	F
1	DATE	RATE1	DATE	RATE2	DATE	RATE3
2	6-Jan	3	6-Jan	4	6-Jan	5
3	6-Feb	4	6-Mar	5	6-Feb	6
4	6-Mar	5	6-Apr	6	6-Mar	7
5	6-May	6	6-May	7	6-Apr	8
6
7
Before

Excel Workbook
	A	B	C	D	E	F
1	DATE	RATE1	DATE	RATE2	DATE	RATE3
2	6-Jan	3	6-Jan	4	6-Jan	5
3	6-Feb	4			6-Feb	6
4	6-Mar	5	6-Mar	5	6-Mar	7
5			6-Apr	6	6-Apr	8
6	6-May	6	6-May	7
7
After