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!