I am using an ms dos based mckesson hosp software

it sends out reports as text and when I import in excel, I have 3 entries going vertically a skipped row, and then 3 more entries going vertically.

EG. Cell A1, A2 & A3 all contain one entry. It skips a line (A4), and then starts again with A5, A6 & A7 being the next entry, and on and on.

How can i get it so say A1, A2 & A3 appear all in A1? (or A1, B1, and C1)

In any case i want them all on one line.

PS - this spreadsheet has over 120k lines all together