Related:
- One column multiple rows (data in sets)
- Excel - Re-arrange data from columns into rows - How-To - Excel
- Converting rows data into columns on conditon ✓ - Forum - Excel
- Convert multiple rows and columns to one colu ✓ - Forum - Excel
- How to convert row data to column in notepad++ ✓ - Forum - Excel
- How to repeat multiple rows in excel - How-To - Excel
2 replies
rizvisa1
- Posts
- 4476
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- August 2, 2020
Try this Olivia. It will take some time as you got just too many rows.
Sub MoveSelection()
Dim lMaxRows As Long
Dim iCol As Integer
lMaxRows = Cells(Rows.Count, "A").End(xlUp).Row
iCol = 2
If (lMaxRows / 22 > Columns.Count - 1) Then
MsgBox ("Data cannot fit in available columns. It needs " & lMaxRows / 22 & " columns where as only " & Columns.Count & " are available")
Exit Sub
End If
Do While lMaxRows >= 22
iCol = iCol + 1
Range(Cells(1, iCol), Cells(22, iCol)) = Range(Cells(23, 2), Cells(44, 2)).Value
Rows("23:44").Delete
lMaxRows = Cells(Rows.Count, "A").End(xlUp).Row
Loop
End Sub
rizvisa1
- Posts
- 4476
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- August 2, 2020
Are you saying that you have all the data in one column and you would like to move it to columns.
Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee.
Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee.
lkc
I have a similar problem, except my data stretches across the rows and I would like to break it down under one "Class" column but still keep the data with the person's name.
First Name, Last Name, ID, Class One, C1 Instructor, Class Two, C2 Instructor, Class Three, C3I
Is there a way to place class 2, C2I, and class 3 with C3I on the next couple of lines under the students' respective names throughout my 1000+ line spreadsheet?
Thank you.
lkc
First Name, Last Name, ID, Class One, C1 Instructor, Class Two, C2 Instructor, Class Three, C3I
Is there a way to place class 2, C2I, and class 3 with C3I on the next couple of lines under the students' respective names throughout my 1000+ line spreadsheet?
Thank you.
lkc
Subscribe To Our Newsletter!
