Need formula to move data on same row and deleting empty rows between data

Hello Guys

Need help by formula to make data on same line.On converting data2 is above data 1 . I insert a column on left . Need to use mouse right click shortcut delete manually shift cells left and then delete shift cells upto have both data on same line but should be in different cells and same sequence per attached ALSO TO REMOVE "/ -DASH HYPENS.

What i need is formula to move the data2 on same alignement and to delete the two empty rows between both data.

See annexed file for expected results.I have preference to have a formula much more .

thanks