How to pull 'Item Description' into column to follow invoice details?

[StillLearning123]

I am using Windows 7 Professional and Microsoft Excel 2010. This is my first post, please bear with me and make suggestions on where I can improve.

In short, I am trying to find the most efficient way to pull an 'Item Description' that is in the first row of invoice details whereby I would like it to follow each line item detail to summarize using a Pivot Table. Format of the data is the first two rows below, followed by an example whereby I would like the 'Item Desc' to follow each 'Ext. P'

[TABLE="width: 500"]
<tbody>[TR]
[TD]Item Number[/TD]
[TD]Item Desc.[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Inv #[/TD]
[TD]Date[/TD]
[TD]Cust. ID[/TD]
[TD]Q[/TD]
[TD]UP[/TD]
[TD]Ext. P[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B123[/TD]
[TD]Client 123[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]01[/TD]
[TD]09/26/2013[/TD]
[TD]WM01[/TD]
[TD]1[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD]INSERT 'Client 123' here[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]