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

thanks Special K

I do agree but am a novice user in excel if there is no solution in formula advise the code i will manage as per file attachment

Regards

JEAN1972

try this code..

Please Login or Register  to view this content.

check the attached file.. for results... and press Alt+F11 for code...




Don't forget to click *

tHANKS A LOT
Just copy the data with values only and using asap utilities to del empty rows happy to manage

Many thanks the code is very good if it could be fine tuned to dashes it will excellent and to delete the empty rows will excellent.
But I managed

great thanks