I am needing to get values between rows with same verbiage in title. Really need help as will have a lot of records to go through. Provided file. IT might help to move the Verbiage to another column
ID Title the Values under Title Status
Thanks in advance
Sub Transpose_my_cells()
Worksheets("Sheet1").Range("A1:c20").Copy
Worksheets("Sheet1").Range("f1").PasteSpecial Transpose:=True
End Sub
This works but I need the ID number in one column, the Title that belongs with the ID"Stock is the current month" in next and the values from column s
12345 12346 12347
Stock is the current month ABC CDE FGI is not valid ABC CDE FGI Stock is not for sale ABC CDE FGI WWW
Good bad bad good Good good bad good Active bad Good bad good
ID Title the Values under Title Status
Thanks in advance
Sub Transpose_my_cells()
Worksheets("Sheet1").Range("A1:c20").Copy
Worksheets("Sheet1").Range("f1").PasteSpecial Transpose:=True
End Sub
This works but I need the ID number in one column, the Title that belongs with the ID"Stock is the current month" in next and the values from column s
12345 12346 12347
Stock is the current month ABC CDE FGI is not valid ABC CDE FGI Stock is not for sale ABC CDE FGI WWW
Good bad bad good Good good bad good Active bad Good bad good