How To Transpose Or Convert A Single Column To Multiple Columns In Excel || dptutorials скачать в хорошем качестве

How To Transpose Or Convert A Single Column To Multiple Columns In Excel || dptutorials

In this tutorial, I will show you How To Transpose Or Convert A Single Column To Multiple Columns In Excel DON'T CLICK THIS: ➡️ https://bit.ly/3sPIZvD Link to download the exercise file: ➡️ https://bit.ly/3j92hay Best Laptops to use for better speed: 1️⃣ https://amzn.to/3lf8zYU 2️⃣ https://amzn.to/3xejpAW 3️⃣ https://amzn.to/379OqeL Best Equipment & Tools for YouTube Channel : ➡️ https://bit.ly/3inKa1P There can be multiple ways to perform this trick, I will show you some of these in this tutorial now. So, let us go to the 1st method: 1.Enter the formula in Cell C1 as =INDIRECT(ADDRESS((ROW($A1)-1)*3+COLUMN(A1),1)) 2. Now let us see the 2nd way of doing this: Using OFFSET Function Enter the formula in Cell C1 as =OFFSET($A$1,COLUMNS($A1:A1)-1+(ROWS($1:1)-1)*3,0) 3. Now let us see the 3rd method of doing this by VB Code: ➡️ VBA Code: Option Explicit Sub movetocolumns() Dim i As Integer, iRow As Integer Dim arrSource As Variant 'Set the first row iRow = 1 With ActiveWorkbook.Worksheets("Sheet1") 'get the data into an array from the first column arrSource = Range(.Cells(1, 1), .Cells(.Rows.Count, 1).End(xlUp)) 'parse every value of the array and add the data to the next column For i = 1 To (UBound(arrSource) - UBound(arrSource) Mod 3) Step 3 .Cells(iRow, 3) = arrSource(i, 1) .Cells(iRow, 4) = arrSource(i + 1, 1) .Cells(iRow, 5) = arrSource(i + 2, 1) iRow = iRow + 1 Next i 'add the remaining values Select Case UBound(arrSource) Mod 3 Case 1 'one item to add .Cells(iRow, 3) = arrSource(i, 1) Case 2 'still two items to add .Cells(iRow, 3) = arrSource(i, 1) .Cells(iRow, 4) = arrSource(i + 1, 1) Case Else 'nothing to add End Select End With End Sub Now go back to the excel sheet and from the view tab, click on view macros and run the macro called “movetocolumns” That’s it friends. Our Recommendations *************************************************************** Oracle Primavera Tutorials : https://bit.ly/3fn9PFH Microsoft Excel Tutorials : https://bit.ly/2V5de5l Microsoft Project Tutorials : https://bit.ly/37guNl7 For Personalized detail learning, write to [email protected] If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later. *********************************************** ★ My Online Tutorials ► https://www.dptutorials.com ⚡️LEARNING RESOURCES I Recommend: https://www.dptutorials.com/resources ⚡️Subscribe for more Awesome Tutorials: http://goo.gl/NyAtg2 ⚡️Support the Channel via shopping: https://amzn.to/2ZRfTOZ http://ift.tt/2jH38PR ⚡️Tools for YouTube vlogging: *********************************************** • Laptop: https://amzn.to/2CaLFxJ • Canon 200D Camera: https://amzn.to/3d7jDR4 • Benro Tripod: https://amzn.to/3exQoax • Microphone: https://amzn.to/3c5lEvS • Collar Microphone: https://amzn.to/2X8DWrS • Screen recorder: https://techsmith.pxf.io/2BMjA • Boom Arm Stand: https://amzn.to/3extb87 • Zoom H1 Audio Recorder: https://amzn.to/2TNdHFj • Harison Softbox Studio Lights: https://amzn.to/3caGbzg • Chroma Key Green Screen: https://amzn.to/2M60mn4 • Background Support Stand: https://amzn.to/3dbACSv • Acoustic Foam Background: https://amzn.to/3gzFtyC • USB RGB LED Strip: https://amzn.to/36BpCLF • Wireless Mouse: https://amzn.to/2TPIrW7 *********************************************** ⚡️You Can Connect with Me at: *********************************************** YouTube:    / dptutorials   Instagram:   / dptutorials   G+: http://ift.tt/2kAOpa6 Twitter:   / dptutorials15   Facebook: http://ift.tt/2kfRnDi BlogSpot: http://ift.tt/2kB14dh Websites: http://www.dptutorials.com & http://www.askplanner.blogspot.com #dptutorials #Exceltraining #ExcelTricks #ExcelTips #ExcelFreeTraining #ExcelFreeLearning ⚡️Tags: - 1 column,one column,multi column,Into,dptutorials,tutorial,how to convert column to row in excel,leila gharani,Convert A Single Column To Multiple Columns,How To Transpose Or Convert A Single Column To Multiple Columns In Excel,single column to matrix in excel,single column into a table in excel,column into array,transpose single column into multiple rows,convert single column into,one column to multiple columns in excel,single column to multiple columns excel