How to re-organize data being returned from a dynamic form?

I receive weekly returns from a dynamic form which are collated into an excel (2007) worksheet. The returned data from each form consists of 5 daily returns (Mon - Fri) of 6 lots of data i.e. 30 items of data per form, and after collection on the worksheet this data is presented as 30 column entries per line - each line being returned from a different source.

In order for me to analyze the data, I need to have the '6 lots of data' organised underneath each other, so that analysis of each column (heading) is easier.

Is there any way in which this re-organization of data can be done other than manually selecting each 5 cell section and dragging it to the required position underneath each other?

Try this:-
Data starts Sheet1 "A1"
Results start "Sheet2 "A1"

Please Login or Register  to view this content.

Regards Mick

Hi Mick, and thanks for the reply. Unfortunately you're dealing with a someone who is only knowledgeable on excel basics, for which I apologise, and would appreciate if you wouldn't mind explaining how to use this.

Regards Barry

I assumed you data is in sheet (1) start at "A1" and consists of a number of row with each rows consisting of 30 cells, each rows needs to be split into groups of 5 cells , so if you have 3 rows, you will end up with 18 rows.
Right click your data sheet tab, select "View Code" , Vb window appears.
On the VB window toolbar, Select "Insert", "Module", new Vbwindow appears.
Paste the code into this VbWindow, Close Vbwindow.
Click "Alt + F8" Macro dialog Box appears, Fom the list select Your code "MG12Jan50", On the right hand side of the dialog box Clik "Run".
The code should now have run and you data Copied to sheet (2) and modified as required.
Regrds Mick

Thanks so much for that Mick, just what I was after and really appreciate it. Presumably, if there were more than 30 column entries would I just change the 30 in 'For n = 1 To 30 Step 5' ?

Regards Barry

Yes, You will get groups of 5 based on that "1 to Number".
Regrds Mick