LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default Transpose after CONCATENATE

In Sheet 3 I Concatenate cells from Sheet 2... now that that worked... i want
to transpose the Conatenated cells (AZ6:AZ235) To Row 4 starting in Column BA.

I have tried this every way I know how and get #REF, 0, and error messages
saying it has to be the same shape cell.

anyone who can help me with this would be greatly appreciated.

Thank You Gurus
 
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
TRANSPOSE Dave F Excel Discussion (Misc queries) 1 August 17th 06 10:09 PM
I WANT TO TRANSPOSE LINKS, AS WE TRANSPOSE VALUES Umair Aslam Excel Worksheet Functions 1 September 22nd 05 01:19 PM
I know how to concatenate ,can one de-concatenate to split date? QUICK BOOKS PROBLEM- New Users to Excel 1 July 26th 05 05:07 PM
Transpose Joe the Toe Excel Worksheet Functions 4 November 12th 04 02:01 PM
TRANSPOSE() bill_morgan_3333 Excel Worksheet Functions 4 November 4th 04 01:10 PM


All times are GMT +1. The time now is 07:02 PM.

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

About Us

"It's about Microsoft Excel"