LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default HELP on TRANSPOSE related function.


HELP PLEASE!

I have a large excel spreadsheet. The layout is like this:

A SDF ED
B EFD BR
C ERT RT

How do I transpose everything using VB so they are in one column lik
this:

A
SDF
ED
B
EFD
BR
C
ERT
RT

THANKS A LOT!

--
sunj9
-----------------------------------------------------------------------
sunj99's Profile: http://www.excelforum.com/member.php...fo&userid=2393
View this thread: http://www.excelforum.com/showthread.php?threadid=37566

 
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
SUMIF FUNCTION works in all cells but those related to one account Skyhawk Excel Worksheet Functions 4 February 7th 09 06:35 AM
related to error function amit saraf Excel Discussion (Misc queries) 4 November 8th 08 11:57 PM
2 questions! Related to combobox and time function. HELP!! Bruno Excel Discussion (Misc queries) 11 September 28th 07 02:33 PM
HELP on TRANSPOSE related function. jindon[_4_] Excel Programming 0 June 1st 05 04:39 PM
Function Related Question Sandeep Arora Excel Discussion (Misc queries) 1 February 2nd 05 07:36 PM


All times are GMT +1. The time now is 01: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"