Code for copy data using VbA code in excel : Can someone please help me to how to code for below snapshots :

[Input][1]


[Output][2]


  [1]: https://i.stack.imgur.com/AgX6l.jpg
  [2]: https://i.stack.imgur.com/spTJ2.jpg