VBA to format sheet

[haribabu]

Hello Excel users,
My requirement is to format the existing input sheet

where name is to be aligned with other records.Expected output should be in this format

I can very well do this Power Query but now i need to do this in VBA. Can any one let me know how to use VBA code for this requirement?

 

[haribabu]

Hello Excel users,
My requirement is to format the existing input sheet View attachment 6452where name is to be aligned with other records.Expected output should be in this formatView attachment 6453
I can very well do this Power Query but now i need to do this in VBA. Can any one let me know how to use VBA code for this requirement?

	Name	Name1
Task ID	Task Name	Task Lead
1	Activity_1
1.1	Activity_1.1	XYZ
1.2	Activity_1.2	ZAB
2	Activity_2
2.1	Activity_2.1	XYZ