Transpose horizontal table to a vertical table via query

Hi all,

The dates in TblHorizontal are required to be enter in this way due to a funky form layout, however, it need to be converted into a TblTableVertical table.

Name | Type | Date 1 | Date 2 | Date 3 | Date 4 | Date 5 | ... etc | Date 36 |
Name | Type | Date 1 | Date 2 | Date 3 | Date 4 | Date 5 | ... etc | Date 36 |
Name | Type | Date 1 | Date 2 | Date 3 | Date 4 | Date 5 | ... etc | Date 36 |

To

Name | Type | Date 1 |
Name | Type | Date 2 |
Name | Type | Date 3 |
Name | Type | ...etc |

Now, while I could write a loop in VBA, but would much prefer to use a query.

I've attempted to use a crosstab but keep failing due to field number (I have around 36 date fields).

Can anybody offer a solution please?

Cheers