Good morning! I'm new to posting on help forums, please bear with me and feel free to offer suggestions on better methods to posting questions. Here it goes...

I'm working from a sales ledger file whereby I want all invoice data in one row although the Item Number & Item Description are on the first row. Rows 2-10 (for example) are the actual details of the invoice: Invoice #; Date; Customer ID; Customer Name; QTY; etc.

Is there a formula or easier way than copying/pasting the "Item Description" to the first column (J in this case) without any related invoice data?

Any feedback is greatly appreciated and I look forward to hearing back!