Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
samsson
 
Posts: n/a
Default Excel should provide an easy way to switch a column into a row, n.

A very useful feature for Excel would be the ability to easily switch a
column of data into a row. This would allow a column of entries to be used
as a row of headers, for example. Excel already allows switching a column
into a row in the charting area, but not in the spreadsheet. One can work
around this by exporting the column into Word, changing the delimiter between
fields from a paragraph mark (normally hidden) to a comma, then re-importing
the data into Excel - which will then be as a row. This would also allow
Access to import the former column into a row, which could then be a list of
field names.
  #2   Report Post  
JulieD
 
Posts: n/a
Default

Hi Samsson

just wondering why copying your column of data
clicking where you want the row and choosing edit / paste special -
transpose
doesn't work for you?

Cheers
JulieD

"samsson" wrote in message
...
A very useful feature for Excel would be the ability to easily switch a
column of data into a row. This would allow a column of entries to be
used
as a row of headers, for example. Excel already allows switching a column
into a row in the charting area, but not in the spreadsheet. One can work
around this by exporting the column into Word, changing the delimiter
between
fields from a paragraph mark (normally hidden) to a comma, then
re-importing
the data into Excel - which will then be as a row. This would also allow
Access to import the former column into a row, which could then be a list
of
field names.



  #3   Report Post  
RagDyeR
 
Posts: n/a
Default

Maybe he never heard of "Transpose"?<g
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

"JulieD" wrote in message
...
Hi Samsson

just wondering why copying your column of data
clicking where you want the row and choosing edit / paste special -
transpose
doesn't work for you?

Cheers
JulieD

"samsson" wrote in message
...
A very useful feature for Excel would be the ability to easily switch a
column of data into a row. This would allow a column of entries to be
used
as a row of headers, for example. Excel already allows switching a column
into a row in the charting area, but not in the spreadsheet. One can work
around this by exporting the column into Word, changing the delimiter
between
fields from a paragraph mark (normally hidden) to a comma, then
re-importing
the data into Excel - which will then be as a row. This would also allow
Access to import the former column into a row, which could then be a list
of
field names.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Check data on colum A and find match on colum b Chris(new user) Excel Discussion (Misc queries) 3 March 20th 05 05:45 PM
Excel aficionado wants to learn Access Hari Excel Discussion (Misc queries) 0 December 3rd 04 06:47 AM
Excel aficionado wants to learn Access Hari Excel Discussion (Misc queries) 0 December 3rd 04 06:45 AM
Excel user desires to learn ABC of Access Hari Excel Discussion (Misc queries) 1 December 3rd 04 03:32 AM
OPENING TWO DIFFERENT EXCEL PROGRAMS EXCEL SPREADSHEETS Excel Discussion (Misc queries) 3 December 3rd 04 12:14 AM


All times are GMT +1. The time now is 05:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"