How do I perform grouping of software with different version under same name? How do I map different software into a common Category/Manufacturer?

This can be achieved with a help of Software Normalization feature. Manual normalization can be performed under Inventory > Installed Software > Software page.

Reference: Installed Software

Other option is to define a normalization rule under Settings > Software Normalization > Software/Exe Normalization Rules page.

Reference: Software Normalization