Formula to colum wise data to Row wise- data

Hi

We get due list for our various customers in a columnar form.
I need a formula to bring them in a row by row
This is useful for writing letters to customers mentioning their date and due amt.
if there is a black data it should not appear Otherwise I have to do it manually
A sample file is attached.

Thanks