Creating multiple rows from single row of data

I have a list of data that has information from column D that is put together with "_". I need to separate this data and create new rows for each row of data with all the same information in columns A:C but with each individual character in column D.

I have attached a spreadsheet that will show the before and after for what the data needs to look like.
Creating new rows with methods question.xlsx

Help is greatly appreciated!

Hi RaydenUK,
try this

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Yet another approach:

Please Login or Register  to view this content.

Ha! Thanks everyone! I actually tried all of these and they work perfect. If I may ask though, what would the code look like to do the reverse? I ask because I have to alter the methods once they are in their own columns, but then I have to put them back into their original format like they started. I really appreciate the help!

Reverse:

Please Login or Register  to view this content.

Thank you walruseggman that works perfect! I am very grateful for everyone's help.