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

Hi
Thanks for your reply
This transpose is a manual
I will have mutiple rows 1000
In such a case this may end with error.
I request a formula for like vlookup or match like this

thanks

Perhaps something like this? using array formula................

Hi
Thank you very much
However in my data file A101 OR A102 WILL be entered I will not enter date.
I request a formula to bring both date and amount colum
if possible to get formula not brining blank cell values

Thanks

See attached file, does this helps?

Hi
Thanks
Again it is looking for date cell

I request a formula to bring values of a101,a102 to bring bothe date and amount colum row by row and bringing the values for which amount is blank for a date

Thanks & Regards

Again Im not sure what you're looking for, you need both date and amount based on A101 and A102, and Im created both of them on Post #6........ maybe other member can help on this............


regards