I have data that I want to transpose, which should be easy enough. However, There's multiple rows I need to transpose in groups. Each last row in each group has a certain TEXT in there, so I don't know if there is some way to create a range searching for text versus a range? (Would this work? =if(isnumber(search(“TEXT”,A1))
. I tried creating a macro, but obviously I need the code to transpose the data down the spreadsheet and not the same data over and over. Any help would be great!
Here is a visual of what I need (Since I cannot format it, it looks funny, and since I'm new I couldn't embed it, so I included a link of a visual of what the rows/column look like/should look like:
From this:
Column A
Row A1
Row A2
Row A3
Row A4
Row A5
Row A6
Row A7
Row A8
Row A9
Row A10
Row A11
Row A12
Row A13
To this:
Col A Col B Col C Col D Col E
Row A1 Row A2 Row A3 Row A4
Row A5 Row A6 Row A7 Row A8 Row A9
Row A10 Row A11 Row A12 Row A13
Here's the loop code I found:
Sub Test1()
'UpdatebyExtendoffice20161222
Dim x As Integer
Application.ScreenUpdating = False
' Set numrows = number of rows of data.
NumRows = Range("A1", Range("A8”).End(xlDown)).Rows.Count
' Select cell a1.
Range("A1").Select
' Establish "For" loop to loop "numrows" number of times.
For x = 1 To NumRows
' Insert your code here.
' Selects cell down 7 row from active cell.
ActiveCell.Offset(7, 0).Select
Next
Application.ScreenUpdating = True
End Sub
A
? Because that would make it quite a bit easier, but your terminology is confusing. … … … … … … … … … … … … … Please do not respond in comments; edit your question to make it clearer and more complete.