"Text to columns" for unorganized notepad

[rupeshec0440]

Hi,






I have a notepad which has around 20 entries. I have to import these entries and convert it into columns. This would have been easy, if present in a single row. but these are broken rows and are present in 4 rows.






Thus, excel converts these entries into 4 different rows while trying to convert from "Text to columns". Is there any way where I can convert all these entries into a single row?






Thanks

 

[DILIPandey]

Since source data is unorganized, I would suggest to get data first in a Excel sheet and then process data there using vba / formulas and then copy to other Excel sheet.



Regards,
DILIPandey