Hi All,

I have a worksheet that looks like this :

---A ------- B ------- C -------- D ------ E --------- F --------
1 John ---- 1001------Day ----- 10.65 ---- Night ---- 3.33 ---
2 Mary ----1002 ----- Day ------11.55----- Night ---- 3.21 ---
3 Mark ----1003------ Day ------13.33 ---- Night ---- 1.23 ---
4 Pete ----1004 ------Day ----- 15.69 ---- Night ---- 5.66 ---
5 Nigel ----1005 ----- Day ----- 17.85 ---- Night ---- 5.22 ---

And i need to reformat it to look like this :

----A --------- B ----- C --------- D ----------- E --------- F --------
1 John ---- 1001------Day ----- 10.65
2 John ---- 1001------Night ---- 3.33
3 Mary ----1002 ----- Day ------11.55
4 Mary ----1002 ----- Night ---- 3.21
5 Mark ----1003------ Day ------13.33
6 Mark ----1003 ----- Night ---- 1.23
7 Pete ----1004 ------Day ----- 15.69
8 Pete ----1004 ----- Night ---- 5.66
9 Nigel----1005 ------ Day ----- 17.85
10 Nigel----1005 ---- Night ---- 5.22

I have thousands of rows and would like a macro to format these.
I have tried using the VBA located here :
http://stackoverflow.com/questions/3...-rows-in-excel

But this does not format them the way i need it and i cannot figure out how to change it correctly.

Can anyone help me here ?

Thanks,
Sarah