is the way you are expecting arrange the pills as like below
attached the workbook
Hope this helps kindly mark this answer as correct or helpful so that it will help others
Port Volumes_v10.2.twbx 48.7 KB
Exactly what i was looking for, thank you very much for your quick and accurate reply.