Need helps for vba - transpose data from single row to multiple rows

[Butterbun]

Hi,

Need helps for vba.
I will get thousand of lines like below image 1 daily. Is there any way to automate from image 1 to image 2?
The tricky part are vendor number and invoice number column can't be repeated on image 2. Also, Dr and Cr have to be showed on image 2 column G based on column D.

image 1
View attachment 101540

image 2

Thank you.

 

[Butterbun]

I apologizes. My image 1 was not showing at the top. Let me attach image 1 and image 2 here again.
Is there any way to automate from image 1 to image 2?
The tricky part are vendor number and invoice number column can't be repeated on image 2. Also, Dr and Cr have to be showed on image 2 column G based on column D.


Image 1

Image 2

Thank you.