Convert Data to diff format (see attached)

[pr4t3ek]

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:

Date Type1Total, Type2 Total, Type3 Total, Type4 Total.

I would like to re-arrange so it shows it as:
Type1 Date Type1Total
Type2 Date Type2Total
Type3 Date Type3Total
Type4 Date Type4Total

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.