Convert multiple column to single column by VBA macros in excel.

Hello Friends
In this video you will learn Convert multiple column to single column in Excel.
Convert multiple column to single column in Excel with formula.
• Convert multiple colum...
How Create Line chart with conditional formatting?
• How Create Line chart ...
How to create speedometer chart in excel?
• How to create speedome...
Please SUBSCRIBE like, Share and comment.
Thank you

[@akashthakur19]

Great work.. really awesome video

[@EngineeringMSExcel]

Thank you

[@hiralpatel6326]

can you copy paste whole code here or in description so it would be easier for viewers.

[@omnathsarraf]

Sub converttocolumntorow_1() Dim rng1 As Range, rng2 As Range, rng3 As Range Dim rowindex As Integer Set rng1 = Application.Selection Set rng1 = Application.InputBox("source range:", "estimate bill", rng1.Address, Type:=8) Set rng2 = Application.InputBox(" convert to single cell", "estimate bill", Type:=8) rowindex = 0 Application.ScreenUpdating = False For Each rng3 In rng1.Rows rng3.Copy rng2.Offset(rowindex, 0).PasteSpecial Paste:=xlPasteAll, Transpose:=True rowindex = rowindex + rng3.Columns.Count Next Application.CutCopyMode = False Application.ScreenUpdating = True End Sub