LinkBack URL
About LinkBacks
An example:
Col AD Col AE Col AF
1 2 3
4 5 6
7 8 9
Result in col AJ should be
1
4
7
2
5
8
3
6
9
The results should ignore blank cells after the last non-blank cell in ciolumns AD, AE and AF.
An example:
Col AD Col AE Col AF
1 2 3
4 5 6
7 8 9
Result in col AJ should be
1
4
7
2
5
8
3
6
9
The results should ignore blank cells after the last non-blank cell in ciolumns AD, AE and AF.
Last edited by MartinLiss; 08-28-2023 at 05:40 PM.
If all 3 Columns are the same length with data.
Or
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by jolivanes; 08-28-2023 at 07:18 PM.
Experience trumps academics every day of the week and twice on Sunday.
Thanks. I know how to do it without Transpose but I'd like to do it with transpose.
Re: How do I stack the contents of 3 columns vertically into one column using VBA
As TRANSPOSE worksheet function is very not appropriate here …
I'm not asking for a Transpose function, but rather transpose VBA code like the following which doesn't and is not intended to do what I want.
Please Login or Register to view this content.
Last edited by AliGW; 08-29-2023 at 01:44 AM. Reason: Code tags added. Please read the guidelines on the rules page.
Are all the columns the same length?
If you use transpose, the outcome will be different from what you ask for in Post #1.
Last edited by jolivanes; 08-28-2023 at 09:27 PM.
Re: How do I stack the contents of 3 columns vertically into one column using VBA
As the Paste Transpose is exactly the same as TRANSPOSE worksheet function and
as your need has nothing to do with any transposition …
Please Login or Register to view this content.
Just go this way, without transpose
Please Login or Register to view this content.
Last edited by JEC.; 08-29-2023 at 06:05 AM.
With transpose
Please Login or Register to view this content.
Last edited by JEC.; 08-29-2023 at 06:05 AM.
Thank you mohadin, your transpose solution works.
JEC I tried your solution and I think your use of a named range is clever but the code gave me a type mismatch error on the second line of the macro.
Re: How do I stack the contents of 3 columns vertically into one column using VBA
Originally Posted by MartinLiss
As his final transpose cancel the previous ones so it's like not using any transpose,
instead of doing A + B it's like doing A - - B, the minus signs are the transpose so useless …
Like you can check yourself just copying a range then pasting it with transpose activated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks