Code & date fix But Time shift row to Column wise |General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hi Suman

You can try using a PivotTable

You will need to sort your data by Code/Date/Time.

You will then need to add a helper column to get the header (Your data must be sorted for this to work).

Hope this helps.

Sunny

Hi Frans

Thanks for your compliments 

For the helper to work, the data need to be sorted in the correct sequence.

This will allow the headers to be generated correctly.

Whenever I have data like these, I will always look into a Pivot Table solution first before others.

In many situation, a helper column or two will be necessary but it is the easiest and most flexible.

VBA (macro) will normally be my last choice.

Sunny