can you possibly send an example of what you are looking to do
i mean send an example file of how the data is arranged and the type of output you are looking for
I see we are not off to a good start.
I don't think it is unreasonable to ask for an excel file that shows how the data is arranged and how you want it to look.
Without that it would be very difficult to help you, a spreadsheet can have basically anything in it.