Need a New Row at Every Instance of a Certain Character (or every X columns)

Greetings! Thank you for this wonderful resource.

I have a huge swath of data from a .CAP file that needs to be parsed out correctly into columns (no problem!) and rows (big problem).
Here is what it currently looks like: Excel1.jpg I've highlighted a few cells here. I need a new row starting at, or even after, each instance of "D".

Manually done, here is what I want:Excel2.jpg

This is what happens when I use "find and replace" to replace each "D" with character 10/ALT+0100/Ctrl+J (the new line character); a large space within each cell rather than the expected hard return/new row at each instance of "D".
Excel3.jpg

This data is already transposed once from a single-column format. I've tried using Transpose while selecting an area in a new sheet of a 'logical' size.

Is there a way to have Excel recognize that "D", or even simply count X number of columns over, and start a new row in column A?