Im relatively new to Excel and want to become better for my job!

[cvalverde]

I have some data that I have retrevead from some Floppy Disks, the data is sometimes a little messy and I have to organize it. For example, sometimes a row of lines will be placed in one single column and I have to go to Data and Text to Column to organize the data in the quickest way possible. Unfortunately, sometimes the data is place in different rows, in one column and I have to go row by row and cut and paste the data and Text To Column each row one by one. I have heard of Macros but I dont know much about them. I would be very grateful if someone could help me to automize the process that I am doing so I dont have to repeat it over and over. If im not clear I can send more pictures or videos if thats allowed! Very happy to enter into the community

 

[DanteAmor]

Hi and welcome to MrExcel.

Maybe it can be solved with a macro.

You could put a sample of your data, use XL2BB tool, see my signature.
In that sample you must put all the possible cases of how your original data is.
In a second sample you must put the desired result.
You put both samples with XL2BB tool to make it more practical to copy the data and make tests.