done by excel expert only

Originally Posted by noorulla

hi fourm
my problem is to convert the data in to colums the data comes like this

name
address
phone number

my job is to convert the data like this in excel sheet
name address phone number

they come in 5 thousands i have to convert to them in diffrent colums
so plese help me to come out from this sitiuation
thanks
noor

One way:

In cell B1 put

=IF(MOD(ROW(),3)=1,A2,"")

In cell C1 put

=IF(MOD(ROW(),3)=1,A3,"")

and formula-fill those down to the extent of your data

Select columns B & C and Copy, then Paste Special = Values back over themselves.

Data, Filter, Auto-filter,
and then, for column B, dropdown and select 'Blanks'

Click the first row shown blank (Row 2) and shift-click the last row shown (to select the full range of blank rows)
Rightmouse those selected rows and 'Delete Row'.

Remove the autofilter.

Let me know how you go.
---