Attached are the current and required output screen shots. Note that i have created the required output in excel 🙂