Another stupid question..

S

Simon L

If I have data running along a column is there anyway to "flip" the dat
so it appears in a row?

Thanks,
Simo
 
J

Jason Morin

Copy the data and do paste special > transpose.

HTH
Jason
Atlanta, GA
-----Original Message-----

If I have data running along a column is there anyway to "flip" the data
so it appears in a row?

Thanks,
Simon


------------------------------------------------
[/url]
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step
Click to expand...
guide to creating financial statements
 
J

John Wilson

Simon,

Data usually runs "down" columns and "across" rows.

Try Edit/Cut or Copy and then
Edit/Paste Special and check the "Transpose" box.

John
 
A

Arvi Laanemets

Hi

Copy data, select a cell elsewhere (not in same range),
PasteSpecial.Transpose

--
(When sending e-mail, use address [email protected])
Arvi Laanemets


Simon L said:
If I have data running along a column is there anyway to "flip" the data
so it appears in a row?

Thanks,
Simon
Click to expand...
creating financial statements
 
S

Simon L

That's great thanks, regarding formatting if the data has symbols at the
start and end of it e.g ",> is there anyway to delete them from all
fields?
 
L

Lady Layla

Edit Replace - enter symbols you want to delete
leave 2nd box blank, Replace all


:
: That's great thanks, regarding formatting if the data has symbols at the
: start and end of it e.g ",> is there anyway to delete them from all
: fields?
:
:
: ------------------------------------------------
: [/url]
:
:
: ~~Now Available: Financial Statements.xls, a step by step guide to creating
financial statements
 
Top