VBA to transpose according to date

[Jedgroev]

Hi,

I would like to transpose my dataset according to the date and time.
Does somebody know how to make a VBA that transposes the dataset automatically?
See the attached file for the example dataset. Note that there are also missing values

Tab 1 = dataset
Tab 2 = an example how the format should look like

example.zip

I hope somebody can help me.

Greets

Johannes

[jindon]

try

Please Login or Register  to view this content.

[Jedgroev]

Woow perfect! Thanks for the reply! This saves me a lot of time