VBA Macro which create new lines by codes

[p45cal]

( Do you have any feedback for p45cal on his attempt for you )

We're getting .xls files but his profile shows Office 2016+ so the Power Queries should work.
In general, if someone I've tried to help completely ignores that help, I return the compliment when they later want further help.
That said, the attached includes a tweak to the query which tries to maintain the formatting.