Another stupid question..

[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

 

[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


------------------------------------------------

~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step

guide to creating financial statements

 

[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

 

[Arvi Laanemets]

Hi

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

--
(When sending e-mail, use address (e-mail address removed))
Arvi Laanemets

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

Thanks,
Simon


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to

creating financial statements

 

[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?

 

[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?
:
:
: ------------------------------------------------
:
:
:
: ~~Now Available: Financial Statements.xls, a step by step guide to creating
financial statements

 

[Simon L]

Legendary, thank you...!