Convert Data to diff format (see attached)

Hi,
Please see the attached file.

In the RawData tab, I have the Type, The Date, and total for that date and type.

Using a macro, i would like to redesign the output(onto another sheet) so it can be updated to a database table(i already have the code to export to database). The output should look like what is in the "OutputExample" tab.

Figures in the OutputExample tab are only for the first three dates.

So currently, I have the output as:

Please Login or Register  to view this content.

please see the attached file to see this from a data perspective..

Most importantly: Because the attached is only an example, If we could get the TypeName(e.g. Type1, Type2, Type3, Type4) from the Raw sheet and the date from the rawsheet + figures also.

Please let me know if there are any questions in relation to this.

Thank you

PS: I need a macro to do this only because ive got like 7 sheets to do & each sheet has around 4k rows each.

Based on your example - perhaps:

Please Login or Register  to view this content.

excellent!!
now, can i just add one extra thing..

How can i amend your code so that it looks in the RawData sheet and see's how many Types there are.

e.g. In my real data, ive infact got 37 Type's, not 4..
And in another sheet, ive got 50 odd etc.

So how can we make it so that it looks at how many types are...

maybe by looking at how columns have a value except column A?

cheers mate!

Assuming no blanks interspersed amongst the headers then:

Please Login or Register  to view this content.

exceelllent, working perfectly that is!! =]