Automate transpose of data

[MARKSTRO]

AUTOMATE TRANSPOSE 2-13-14.xlsx
In the attached file, I am looking to automate the transposing of the date and numbers under each bold number.
Data is truck # in bold, the engine oil change date and mileage below.
I copied the data from a pivot and need the date and mileage in columns, date on top with mileage below. I can do it with paste special one truck at a time, the big chunk of data is about 2000 rows deep and was hoping the transpose paste special could be automated, I've made a few attempts on how to do it but can't get it.
Thanks

[RobertMika]

How your desired outcome will look like?

[MARKSTRO]

CURRENTLY
A
TRUCK #
DATE 1 MILEAGE
DATE 2 "
DATE 3 "
DATE 4 "

TRANSPOSED TO:

A B C
7000 DATE 1 MILES FOR THAT DATE
7000 DATE 2 "
7000 DATE 3 "
7000 DATE 4 " ETC.

If the truck number can be inserted/copied down in Col A next to the date in Col B that would be great as well.

[MARKSTRO]

CURRENTLY
A
TRUCK #
DATE 1 MILEAGE
DATE 2 "
DATE 3 "
DATE 4 "

TRANSPOSED TO:

A B C
7000 DATE 1 MILES FOR THAT DATE
7000 DATE 2 "
7000 DATE 3 "
7000 DATE 4 " ETC.

If the truck number can be inserted/copied down in Col A next to the date in Col B that would be great as well.

[RobertMika]

Please see attached

AUTOMATE TRANSPOSE 2-13-14.xlsx

[MARKSTRO]

I had to retype the formulas manually, I could not copy them from your example for some reason. Anyway, it worked, thanks so much.

[RobertMika]

You are welcome.
Appreciate your reputation