Transpose data

[ccollett]

I have a data file made up of 3 columns, 17520 rows consisting of date, half hour increments of time and a value against each half hour (this is for a years worth of data)
I need the data to be in 365 rows (one for each day) and 48 columns (one for each half hour of the day)
Is there a function in excel to transpose / sort the data into this format?

 

[texasalynn]

Welcome to MrExcel board...

post a small sample of you current data layout and the way you expect the results

 

[Marc]

Hi-

My code assumes that you have no column headers and that your data starts in A1 and ends at C17520.

This will paste your values in Column C in the range E1:AZ365

Regards, Marc


Sub TRON()

a = 1
For i = 1 To 365

Range(Cells(a, 3), Cells(a + 48, 3)).Copy

Range("E" & i).PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=True
a = a + 48
Next i
End Sub

 

[ccollett]

Thanks for this, must of had a senior moment as i tried a pivot table and got the info out in the required format.
Regards
C