AAAAgggghhh!
So the file is named after the Max no. of tries per sequence which in this case for AECWC00001 is MCY, but instead of 71 for MCY you want the total of all Devices, 78 in this case?!

Kit no. AECWC00001 is the only one to have a mix of DEVICEs, but it's also the only one to have only one Sequence ID.

Surely, you have Kit no.s which have a mix of DEVICEs AND multiple Sequence IDs?!

So that I can understand exactly what you want, let's have another data.xlsx file where you include in your sample data at least one (preferably more) such Kit No and the csv file(s) that would result from those one or more Kit No.s.

Sorry about this.