I am fairly limited on knowledge for excel so any help would be appreciated.
I am importing data from another program into excel. I need to have the data
in cells listed in each row converted to data in columns... Please help.

so, you want to transpose the data?

Copy the set, go to a blank spot, Edit/Paste Special and check the transpose
box.

"Carol" wrote:

I am fairly limited on knowledge for excel so any help would be appreciated.
I am importing data from another program into excel. I need to have the data
in cells listed in each row converted to data in columns... Please help.

Depending upon the layout you may be able to do a simple copypaste
specialtranspose.

See help for more.

Or post more details on your layout.


Gord Dibben MS Excel MVP

On Fri, 30 Oct 2009 10:30:16 -0700, Carol
wrote:

I am fairly limited on knowledge for excel so any help would be appreciated.
I am importing data from another program into excel. I need to have the data
in cells listed in each row converted to data in columns... Please help.