I'm importing a big file and need to switch the data from rows into columns. The import file is .txt with fields separated by blanks like this:
100 London Paris Geneva Moscow Turin
101 Washington Caracas Brussels Dublin
And I need to transpose it into a format like this in Excel.
Paste Special - Transpose doesn't quite do it. Any suggestions much appreciated as it I am spending an age doing this manually at the moment. David Carter