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.
Bookmarks