I have a table x(pasted below), which includes different values for VM, vCPU, RAM, Disk and VM Count.

input table.PNG

Now as per above table I need to create another table y (with fixed number of rows and collumns) which will have different number of merged cells as per the VM and vCPU collumn from table x. e.g.

output table.PNG

I need to accomodate all the VMs from table x in table y with the mentioned number of vCPU size. In table y, one cell represent 2 vCPUs. Need urgent support to achive this by Macro.

Please let me know if any other information required to proceed further on this.