Macro for to transpose selected cells

sanz · Jul 22, 2011

Hi,

I want a macro for selecting No of cell in Column "A" and Paste transposing it in Column "C"

Eg:- Select "1,2,3,8" cells from column A and Transpose it in Column "C"

 <table class="MsoNormalTable" style="width: 240pt; margin-left: 4.65pt; border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0" width="320"> <tbody><tr style="height: 15.75pt;"> <td style="width: 48pt; border-width: 1pt 1pt medium; border-style: solid solid none; border-color: windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15.75pt;" nowrap="nowrap" valign="bottom" width="64"> Input
</td> <td colspan="4" style="width: 192pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext black windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15.75pt;" nowrap="nowrap" valign="bottom" width="256"> Output
</td> </tr> <tr style="height: 15pt;"> <td style="width: 48pt; border: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"> 1
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"> 1
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"> 2
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"> 3
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"> 8
</td> </tr> <tr style="height: 15pt;"> <td style="width: 48pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"> 2
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 48pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"> 3
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 48pt; border-width: medium 1pt; border-style: none solid; border-color: -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"> 8
</td> <td style="width: 48pt; border-width: medium 1pt medium medium; border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
</td> <td style="width: 48pt; border-width: medium 1pt medium medium; border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
</td> <td style="width: 48pt; border-width: medium 1pt medium medium; border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
</td> <td style="width: 48pt; border-width: medium 1pt medium medium; border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 48pt; border-width: 1pt medium medium 1pt; border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
</td> <td style="width: 48pt; border-width: 1pt medium medium; border-style: solid none none; border-color: windowtext -moz-use-text-color -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
</td> <td style="width: 48pt; border-width: 1pt medium medium; border-style: solid none none; border-color: windowtext -moz-use-text-color -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
</td> <td style="width: 48pt; border-width: 1pt medium medium; border-style: solid none none; border-color: windowtext -moz-use-text-color -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
</td> <td style="width: 48pt; border-width: 1pt 1pt medium medium; border-style: solid solid none none; border-color: windowtext windowtext -moz-use-text-color -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 48pt; border-width: medium medium 1pt 1pt; border-style: none none solid solid; border-color: -moz-use-text-color -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
</td> <td style="width: 48pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
</td> <td style="width: 48pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
</td> <td style="width: 48pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 48pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"> 4
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"> 4
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"> 5
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"> 6
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"> 7
</td> </tr> <tr style="height: 15pt;"> <td style="width: 48pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"> 5
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 48pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64"> 6
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="64">
</td> </tr> <tr style="height: 15.75pt;"> <td style="width: 48pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 15.75pt;" nowrap="nowrap" valign="bottom" width="64"> 7
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15.75pt;" nowrap="nowrap" valign="bottom" width="64">
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15.75pt;" nowrap="nowrap" valign="bottom" width="64">
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15.75pt;" nowrap="nowrap" valign="bottom" width="64">
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15.75pt;" nowrap="nowrap" valign="bottom" width="64">
</td> </tr> </tbody></table>
Any help would be much appreciated !

wigi · Jul 22, 2011

For instance

Code:

Sub transposing_wigi()
    With Selection
        .Offset(, 2).Cells(1).Resize(, .Rows.Count) = Application.Transpose(.Value)
    End With
End Sub

Stacko · Jul 22, 2011

Or you could do Copy-Paste Special (Transpose).

GlennUK · Jul 22, 2011

Stacko said:
Or you could do Copy-Paste Special (Transpose).

Yeah, I said that in the duplicate thread:

http://www.mrexcel.com/forum/showthread.php?t=566201

Stacko · Jul 22, 2011

Great minds!

GlennUK · Jul 22, 2011

Stacko said:
Great minds!

Yes indeed!

Macro for to transpose selected cells

sanz

Board Regular

Excel Facts

wigi

Well-known Member

Stacko

New Member

GlennUK

Well-known Member

Stacko

New Member

GlennUK

Well-known Member

Similar threads

Forum statistics

Share this page

Macro for to transpose selected cells

sanz

Board Regular

Excel Facts

wigi

Well-known Member

Stacko

New Member

GlennUK

Well-known Member

Stacko

New Member

GlennUK

Well-known Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock