Hi..
I need help
I have data in ms excel and i need to transpose into four groups
I have attached sample file in excel
First sheet is "Data"
second sheet is "output" where how the data should be in into by four groups
Thanks
Mathanraj
Hi..
I need help
I have data in ms excel and i need to transpose into four groups
I have attached sample file in excel
First sheet is "Data"
second sheet is "output" where how the data should be in into by four groups
Thanks
Mathanraj
Sub a() drow = 2 Set sh1 = Sheets("Data") Set sh2 = Sheets("Output") LR = sh1.Cells(Rows.Count, "A").End(xlUp).Row sh2.Select c = 1 For j = 2 To LR 'Step 4 Range(Cells(drow, c), Cells(drow, c + 4)).Value = sh1.Range(sh1.Cells(j, 1), sh1.Cells(j, 5)).Value c = c + 5 If c > 16 Then drow = drow + 1 c = 1 End If Next End Sub
If solved remember to mark Thread as solved
Thanks
you solved my problems
Mathanraj
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks