turn a row into a column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shelley - 18 Dec 2007 10:01 GMT

Hi,

I imported data from the internet and got a list that I wanted as one
column into the first row. That means, that each name is in a new
column...

Is there a simple way to turn a row into a column?

Thanks, Shelley.

Reply to this Message

Pete_UK - 18 Dec 2007 10:21 GMT

Highlight the data you want to swap and click <copy>, then move your
cursor to where you want the data to be moved to (it must be outside
the area occupied by the current data, eg if the data is in row 1,
then move cursor to A2, or A3). Click on Edit | Paste Special | Values
(check) | Transpose (check) | OK then press <Esc>.

Then you can delete the row where the current data is, if you want to.

Hope this helps.

Pete

> Hi,
>
[quoted text clipped - 5 lines]
>
> Thanks, Shelley.

Reply to this Message