I have imported 5000+ lines of data which was copied from a .pdf - unfortunately although it was laid out in the .pdf in 4 columns, it has imported into Excel all in one column e.g.
A1=Title 1
A2=Title 2
A3=Title 3
A4=Title 4
A5=Data 1
A6=Data 2
A7=Data 3
A8=Data 4
I need it to be:
A1=Title...