how to convert lot of data into 4 coloumn?

Question

i have 20000 data in following format & every time it mention
Name             
Address          
Phone             
Fax               
in this way
so how do i convert it all data into column
as like
Name             Address          Phone             Fax          

this is the common format for all data
     
Please help if somebody's know it.

Answer 1

If data is in Table::

(1) Put the cursor on the last cell of any row

(2) Click the menu 'Table', insert, columns to the right

In the inserted column, there will be no data

Now, you decide which data should be in which column

Accordingly, you cut and paste the data to the concerned cell/column



If data is in columns::

Click the menu 'Format', columns

You select the no. of columns

Decide which data should be in which column

Accordingly, you cut and paste the data to the concerned data



I will the tell one example

There are data in three columns

Now, you want four columns

Click menu 'Format', columns

select no. of columns : 4; click O.K.

If you want some data to be copied into 4th column, copy them

Put cursor at the end of third column

Now, press Tab in key board continuously till you land on 4th column; paste the data

Answer 2

Ensure that every next field(name, address, phone and fax) is in fifth cell from its current location.

Record a macro by moving address to 2rd column, phone to 3rd column and fax to 4th column. click on next address and close the recording. run the macro as require.



Try this only a copied file.

Answer 3

why cant u try sql query solution thru it is easy and googl it