Convert table data to another sheet

[cemregunay]

Hello Dear Forum Members and Managements,

I have a table in Sheet1 and it's about of student's name, lessons and class.

I want to create a macro which convert to all data like Sheet2.

Thanks in advance for your kindly help.

Regards

[Kaper]

Why macro - formula shall be enough:

Please Login or Register  to view this content.

to make it working faster limit input range:

Please Login or Register  to view this content.

Of course, once you know the formula, you can write a macro which mimmics the formula action


PS. in sample data you have a mistake: Merve KUŞÇU on Perşembe has no class 2/A (while you wrote RİTİM in F5)

[cemregunay]

Thanks a lot Mr. Kaper.

Regards