how to import data from a single-column text file to a multi-columntable?

T

Tony Young

Hi,

I have a text file (.txt) which maintains only one column of data. Is
there a way to import the data to a 3-column table so that the data will
be fed into the 1st column on the 1st page, then 2nd and 3rd columns.
If there are more data, the rest will be fed into the columns on the
next pages in the same manner? Please see the illustration below. Can
MS Excel do a better job in this regard? Your help is much appreciated.

1st page:
1 7 13
2 8 14
3 9 15
4 10 16
5 11 17
6 12 18

2nd page:
19 25 31
20 26 32
21 27 33
22 28
23 29
24 30

Tony
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Two columns followed by single page-width column on same page 0
How to center adjust text above and image in a two column document. 1
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
create a formula to know last months column character or number 0
Help!! find two number recurring numbers in row?? 1
formula for transpose 1
Single column to multiple columns 5

Top