Hello all,

I need to rearrange some data, like students have multiple subjects (max 4 subjects but some may have less subjects) and marks accordingly in rows. I want the data in column format. I add the excel file for your suggestion.

Click image for larger version. 

Name:	data-setup-problem.PNG 
Views:	10 
Size:	61.0 KB 
ID:	10409

Thank you for your help in advanc