Import data in Excel that doesn't have a row delimiter, but number of columns is known
- by Alex B
So i have this text file that looks something like this:
Header1 Header2 Header3 Header4 A1 B1 C1 D1 A2 B2 C2 D2
and so on.
When imported, I'd want the data to format itself in 4 columns. I tried the Get External Data from Text, and it successfully imports it, but it doesn't wrap it around, so it just keeps making columns for every space.…