Horizontal lookup return data vertically (Index Match ?)

I am trying to return a vertical collation of order data from a horizontal order table supplied by a client that cannot be changed. I have attempted index match, an array all to no avail.

The order table ‘ORDER FORM’ displays the order numbers in column A and starts in row 5.

The individual lines that I need to be returned to the ‘OrderCollate’ tab start from column R through to column BR (Although this could be extended)

What I need is to find the related order number in column A and return the values of that row between Columns R through to BR that have values in them ignoring all blanks. I then need to return the SKU header that is in row 1 which relates to the cells that have a value;

Eg;

Order number 10013
SKU Qty
CE041301A 1
CE041302A 1
CEI080 2
CE041345A 1
CE041313A 1

Order number 10019
CE041332A 1

Order number 10025
CE041340A 1

I have attached the spreadsheet and OrderCollate shows the results I require, but not the formula to do what I require. I will only be looking for one order number each time, we will be using this information to produce a pick/check sheet.

Any advice would be greatly appreciated.

Many thanks

Richard