Transpose, Offset, Match

Dear Sir,
i want to transpose the data in sequential row, on multiple criteria from different column of the data sheet.

Hi NOOR8225

Does the attached do what you requested?

I would have thought that it might be easier if you used the employee code, rather than the employee name? (But I have done as you requested)

Let me know if you have any queries

Regards
Alastair