A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Past Special- Transpose Function?



 
 
Thread Tools Display Modes
  #1  
Old May 25th, 2010, 05:36 PM posted to microsoft.public.excel.misc
Going Crazy with excel[_2_]
external usenet poster
 
Posts: 16
Default Past Special- Transpose Function?

I have a master data base of 20 columns of data. I want to transpose only 6
columns of that data to a different sheet, automatically recognizing the
column headers from the master sheet to the matching column headers on a
separte sheet. I suspect this can be acomplished with the Transpose
Function. Just can't figure out how. Any help would be greatly appreciated.

  #2  
Old May 25th, 2010, 06:48 PM posted to microsoft.public.excel.misc
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Past Special- Transpose Function?

Not clear with your description.

Transpose means rotating the data by 90 degrees.

What do column headers in either sheet have to do with that?


Gord Dibben MS Excel MVP

On Tue, 25 May 2010 09:36:01 -0700, Going Crazy with excel
wrote:

I have a master data base of 20 columns of data. I want to transpose only 6
columns of that data to a different sheet, automatically recognizing the
column headers from the master sheet to the matching column headers on a
separte sheet. I suspect this can be acomplished with the Transpose
Function. Just can't figure out how. Any help would be greatly appreciated.


  #3  
Old May 25th, 2010, 08:26 PM posted to microsoft.public.excel.misc
Fred Smith[_4_]
external usenet poster
 
Posts: 2,386
Default Past Special- Transpose Function?

Do you mean "transfer" as opposed to "transpose"?

If so, hopefully the columns in your two sheets are in the same order. If
so, just hide the unwanted 14 columns in your master data base, copy the
visible cells, then unhide the columns.

Regards,
Fred

"Going Crazy with excel"
wrote in message ...
I have a master data base of 20 columns of data. I want to transpose only
6
columns of that data to a different sheet, automatically recognizing the
column headers from the master sheet to the matching column headers on a
separte sheet. I suspect this can be acomplished with the Transpose
Function. Just can't figure out how. Any help would be greatly
appreciated.


  #4  
Old May 25th, 2010, 08:33 PM posted to microsoft.public.excel.misc
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Past Special- Transpose Function?

Sounds like a good plan Fred.

See what OP comes back with.


Gord

On Tue, 25 May 2010 13:26:31 -0600, "Fred Smith"
wrote:

Do you mean "transfer" as opposed to "transpose"?

If so, hopefully the columns in your two sheets are in the same order. If
so, just hide the unwanted 14 columns in your master data base, copy the
visible cells, then unhide the columns.

Regards,
Fred

"Going Crazy with excel"
wrote in message ...
I have a master data base of 20 columns of data. I want to transpose only
6
columns of that data to a different sheet, automatically recognizing the
column headers from the master sheet to the matching column headers on a
separte sheet. I suspect this can be acomplished with the Transpose
Function. Just can't figure out how. Any help would be greatly
appreciated.


  #5  
Old May 25th, 2010, 09:08 PM posted to microsoft.public.excel.misc
Going Crazy with excel[_2_]
external usenet poster
 
Posts: 16
Default Past Special- Transpose Function?

You are exactly correct. Real bad terminology. Should have used "copy".
I have 20 columns with data assigned to a particular individual. I want to
"copy" various columns, same information and format, to a different sheet,
without having to go thru the motions of "copy-paste" on each column to the
next. Maybe what I am looking for is an array formula. Example, row "A" is
Bill with 100 data entries in the column. Then copy paste the array formula
on the second page, and the array will fill in the column. Am I still
confusing you?

"Gord Dibben" wrote:

Not clear with your description.

Transpose means rotating the data by 90 degrees.

What do column headers in either sheet have to do with that?


Gord Dibben MS Excel MVP

On Tue, 25 May 2010 09:36:01 -0700, Going Crazy with excel
wrote:

I have a master data base of 20 columns of data. I want to transpose only 6
columns of that data to a different sheet, automatically recognizing the
column headers from the master sheet to the matching column headers on a
separte sheet. I suspect this can be acomplished with the Transpose
Function. Just can't figure out how. Any help would be greatly appreciated.


.

  #6  
Old May 25th, 2010, 09:23 PM posted to microsoft.public.excel.misc
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Past Special- Transpose Function?

"A" is not a row. It is a column.

See Fred's reply regarding hiding columns then select visible data and
copy/paste to other sheet.

Or possibly use autofilter to pick up just "same information"?

You can always copy/paste specialpaste link if you desire to keep the data
updating.

Note: with paste link you will have to take an extra step to also paste the
formats.


Gord

On Tue, 25 May 2010 13:08:01 -0700, Going Crazy with excel
wrote:

You are exactly correct. Real bad terminology. Should have used "copy".
I have 20 columns with data assigned to a particular individual. I want to
"copy" various columns, same information and format, to a different sheet,
without having to go thru the motions of "copy-paste" on each column to the
next. Maybe what I am looking for is an array formula. Example, row "A" is
Bill with 100 data entries in the column. Then copy paste the array formula
on the second page, and the array will fill in the column. Am I still
confusing you?

"Gord Dibben" wrote:

Not clear with your description.

Transpose means rotating the data by 90 degrees.

What do column headers in either sheet have to do with that?


Gord Dibben MS Excel MVP

On Tue, 25 May 2010 09:36:01 -0700, Going Crazy with excel
wrote:

I have a master data base of 20 columns of data. I want to transpose only 6
columns of that data to a different sheet, automatically recognizing the
column headers from the master sheet to the matching column headers on a
separte sheet. I suspect this can be acomplished with the Transpose
Function. Just can't figure out how. Any help would be greatly appreciated.


.


  #7  
Old May 25th, 2010, 10:20 PM posted to microsoft.public.excel.misc
Going Crazy with excel[_2_]
external usenet poster
 
Posts: 16
Default Past Special- Transpose Function?

Thought of that as well. Unfortunately, doesn't solve my problem. Master
columns are 1-20. On new sheet, they will vary in the order of the column.
Column 1 may be in the 7th spot, etc. Good plan but.....

"Gord Dibben" wrote:

Sounds like a good plan Fred.

See what OP comes back with.


Gord

On Tue, 25 May 2010 13:26:31 -0600, "Fred Smith"
wrote:

Do you mean "transfer" as opposed to "transpose"?

If so, hopefully the columns in your two sheets are in the same order. If
so, just hide the unwanted 14 columns in your master data base, copy the
visible cells, then unhide the columns.

Regards,
Fred

"Going Crazy with excel"
wrote in message ...
I have a master data base of 20 columns of data. I want to transpose only
6
columns of that data to a different sheet, automatically recognizing the
column headers from the master sheet to the matching column headers on a
separte sheet. I suspect this can be acomplished with the Transpose
Function. Just can't figure out how. Any help would be greatly
appreciated.


.

  #8  
Old May 26th, 2010, 12:36 AM posted to microsoft.public.excel.misc
Fred Smith[_4_]
external usenet poster
 
Posts: 2,386
Default Past Special- Transpose Function?

But as long as they are in the same order, the plan will work. If you want,
say, columns 7, 10, 14, 15, 18 and 20 from the master copied to the new
sheet, hide columns 1 to 6, 8, 9, 11, 12, 13, 16, 17 and 19. Then copy.

If they're not in the same order, you could have a hidden row on the new
sheet which sorts the columns for you.

Or, a macro might be your best solution.

Regards,
Fred

"Going Crazy with excel"
wrote in message ...
Thought of that as well. Unfortunately, doesn't solve my problem. Master
columns are 1-20. On new sheet, they will vary in the order of the
column.
Column 1 may be in the 7th spot, etc. Good plan but.....

"Gord Dibben" wrote:

Sounds like a good plan Fred.

See what OP comes back with.


Gord

On Tue, 25 May 2010 13:26:31 -0600, "Fred Smith"
wrote:

Do you mean "transfer" as opposed to "transpose"?

If so, hopefully the columns in your two sheets are in the same order.
If
so, just hide the unwanted 14 columns in your master data base, copy the
visible cells, then unhide the columns.

Regards,
Fred

"Going Crazy with excel"
wrote in message
...
I have a master data base of 20 columns of data. I want to transpose
only
6
columns of that data to a different sheet, automatically recognizing
the
column headers from the master sheet to the matching column headers on
a
separte sheet. I suspect this can be acomplished with the Transpose
Function. Just can't figure out how. Any help would be greatly
appreciated.


.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:51 PM.


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