Data spilt in one cell to rows

Hi all,

Attached is a file which has data in table format. The cells in column E (E2 & E3) contain 3 lines of data (i.e. 3 different supplier names), which are required to be spilt in to 3 separate rows each for both the cells & also the information in that particular row should appear as is while the spilt is done.

Any help is greatly appreciated.

Happy New year in advance to all.! Stay safe & enjoy your holidays

Thanks,
Mahesh