Dear All,
Please find attached my requirement. The source sheet contains the source data and the same needs to be transformed to the format which is available in OUTPUT sheet. There are 3 conditions.. 1.Rep Period 2.PID 3.ORIGLT.... if all these 3 matches for the subsequent rows in source sheet then needs to be sumup all the columns from D thru S and place it in OUTPUT. If Rep Period & PID is matching and ORIGLT not matching for subsequent then in the same table next row to be updated based on the ORIGLT value. IF PID is not matching for subsequent rows then the same table needs to copy pasted in the right side for the same Rep Period (as these two PIDs belongs to same period) and sum up paste the data based on the ORIGLT. Finally if the Rep Period is not matching with the subsequent rows, then we need to copy the entire first table and paste the same in the bottom and sum up based on ORIGLT and paste in OUTPUT.
I have prepared the OUTPUT sheet using the formulas only, so everything will be clear if you have a look at the source / output.
Thanks a lot for your help and continuous support.
Bookmarks