NEED HELP TO ARRANGE SYSTEM GENERATED DATA

[KRIXX]

KINDLY HELP ME TO ARRANGE SYSTEM GENERATED DATA IN TO TABLE.

I KNOW IT WILL BE KIND OF COMPLICATED AND TRICKY, BUT I FIRMLY BELIEVE THAT YOU GUYS WILL DEFINITELY DO IT.

SYSTEM GENERATED DATA ARRANGEMENT / FORMAT OF FILE :

Material_Transaction_Report.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Item Code :	102000031	Organization : P95
2	Description :	ALL ALLUMINIUM ALLOY CONDUCTOR 34 SQMM WEASEL	Subinventory : P9507
3	Unit of Measure:	KM	Initial Onhand Quantity : 440.675
4	Period from	19-MAR-20 to 19-MAR-20
5	S.No	Transaction Date	Transaction Type	Req/Move Order No.	Transfer Subinventory	Transaction Quantity	On hand Quantity	Contractor Name	Work Order Number	Sub Work Orde	Description	Supplier	Challan No.	Challan Date	PO No.	Release No	Release Date
6	1	19-Mar-20	Move Order Transfer	23107353	P9502	3.783	444.458				CR.MO. From WO.699/24-12-19, PO.159557, Scheme:-SPA, Cont.: SHRI ASHAPURA ELEC. (DYP.SD.)
7	2	19-Mar-20	Move Order Transfer	23097978	P9502	-12.175	432.283				MO. For SR.12321640/12494719/12471500/12095779/12385287/12321910/12484994/11840582/ 12553994/12544985/12576740/12528992/12553905/12514254/12556240, Scheme:SPA, WO.709/10-2-20, PO.160878, Cont:-Shri Ashapura Elec. (DYP.SD.)
8	3	19-Mar-20	Move Order Transfer	23098531	P9502	-0.179	432.104				MO. For SR.12492304, Manilal Ramji -Dolatpar, Scheme:SPA, WO.601/02-03-19, PO.151519, Cont.: Shri Ashapura Elec. (DYP.SD.)
9	4	19-Mar-20	Issue To Projects	23033923		-12.39	419.714	SHREE ASHAPURA ELECTRICS	159433	2	MO. for Project-261169, Maint. of Ghadani Ag. Under SSVY 19-20, Scheme:SKJY, WO.696/20-12-19(PO.159433), Cont: Shri Ashapura Elec.(RVP.SD.)
10	Item Code :	102000033	Organization : P95
11	Description :	ALL ALLUMINIUM ALLOY CNDUCTOR 55 SQMM RABBIT	Subinventory : P9507
12	Unit of Measure:	KM	Initial Onhand Quantity : 329.507
13	Period from	19-MAR-20 to 19-MAR-20
14	S.No	Transaction Date	Transaction Type	Req/Move Order No.	Transfer Subinventory	Transaction Quantity	On hand Quantity	Contractor Name	Work Order Number	Sub Work Orde	Description	Supplier	Challan No.	Challan Date	PO No.	Release No	Release Date
15	1	19-Mar-20	Move Order Transfer	23097644	P9502	5.37	334.877				CR.MO. From 3rd.& Final Bill of WO:601/2-3-19, PO.151519, Scheme:Coastal, Cont:SHRI ASHAPURA ELEC. (DYP.SD.)
16	2	19-Mar-20	Move Order Transfer	23107354	P9502	0.149	335.026				CR.MO. From WO.699/24-12-19, PO.159557, Project-255230, Maint. of Baranda JGY Feeder Under SSVY 2019-20, Scheme:-Coastal, Cont.: SHRI ASHAPURA ELEC. (DYP.SD.)
17	3	19-Mar-20	Issue To Projects	23098380		-45.517	289.509	SHREE ASHAPURA ELECTRICS	160878	2	MO. For Project-261412, Maint.of KANER JGY Under SSVY 2019-20, Scheme:Coastal(SSVY), WO:709/10-2-20, PO.160878, Cont:-SHRI ASHAPURA ELEC. (DYP.SD.)
18	Item Code :	103000002	Organization : P95
19	Description :	G I WIRE 8 SWG 4MM	Subinventory : P9507
20	Unit of Measure:	KG	Initial Onhand Quantity : 13138.84
21	Period from	19-MAR-20 to 19-MAR-20
22	S.No	Transaction Date	Transaction Type	Req/Move Order No.	Transfer Subinventory	Transaction Quantity	On hand Quantity	Contractor Name	Work Order Number	Sub Work Orde	Description	Supplier	Challan No.	Challan Date	PO No.	Release No	Release Date
23	1	19-Mar-20	Move Order Transfer	23107353	P9502	40	13178.84				CR.MO. From WO.699/24-12-19, PO.159557, Scheme:-SPA, Cont.: SHRI ASHAPURA ELEC. (DYP.SD.)
24	2	19-Mar-20	Issue To Projects	22977062		-91	13087.84	SHREE ASHAPURA ELECTRICS	159557	3	MO. For Project-255230, Maint. of Baranda JGY Feeder Under SSVY 2019-20, Scheme:Coastal, WO.699/24-12-19(PO.159557), Cont.: SHRI ASHAPURA ELEC.(Dayapar SD.)
25	3	19-Mar-20	Move Order Transfer	23097978	P9502	-332.5	12755.34				MO. For SR.12321640/12494719/12471500/12095779/12385287/12321910/12484994/11840582/ 12553994/12544985/12576740/12528992/12553905/12514254/12556240, Scheme:SPA, WO.709/10-2-20, PO.160878, Cont:-Shri Ashapura Elec. (DYP.SD.)
26	4	19-Mar-20	Issue To Projects	23098380		-912.5	11842.84	SHREE ASHAPURA ELECTRICS	160878	2	MO. For Project-261412, Maint.of KANER JGY Under SSVY 2019-20, Scheme:Coastal(SSVY), WO:709/10-2-20, PO.160878, Cont:-SHRI ASHAPURA ELEC. (DYP.SD.)
27	5	19-Mar-20	Move Order Transfer	23098531	P9502	-12.5	11830.34				MO. For SR.12492304, Manilal Ramji -Dolatpar, Scheme:SPA, WO.601/02-03-19, PO.151519, Cont.: Shri Ashapura Elec. (DYP.SD.)
28	6	19-Mar-20	Move Order Transfer	23098599	P9502	-22.5	11807.84				Add.MO. For Project-214561, Dolatpar Ag. Under SSVY, Scheme:Coastal, WO:601/2-3-19, PO.151519, Cont:SHRI ASHAPURA ELEC. NOTE: due to Project date more than 6 month, then linkup MO. "Issue to project" not make in e-urja project module.
29	7	19-Mar-20	Move Order Transfer	23099635	P9503	-245	11562.84				MO. for SR.11599415/12005850/12336396/12277381/12234164/12225229/12393606/12424704/ 11886348/12478257/11805062/12170767, Scheme:SPA, WO.696/20-12-19, PO.159433, Cont: Shri Ashapu6ra Elec.(RVP.SD.)
30	8	19-Mar-20	Issue To Projects	23033924		-75	11487.84	SHREE ASHAPURA ELECTRICS	159433	3	MO. for Project-267629, Bifurgation of Ghadani Ag.Feeder, Scheme:SKJY, WO.696/20-12-19(PO.159433), Cont: Shri Ashapura Elec.(RVP.SD.)
31	Item Code :	103000003	Organization : P95
32	Description :	G I WIRE 10 SWG 3.15 MM	Subinventory : P9507
33	Unit of Measure:	KG	Initial Onhand Quantity : 266.5
34	Period from	19-MAR-20 to 19-MAR-20
35	S.No	Transaction Date	Transaction Type	Req/Move Order No.	Transfer Subinventory	Transaction Quantity	On hand Quantity	Contractor Name	Work Order Number	Sub Work Orde	Description	Supplier	Challan No.	Challan Date	PO No.	Release No	Release Date
36	1	19-Mar-20	Issue To Projects	22977062		-266.5	0	SHREE ASHAPURA ELECTRICS	159557	3	MO. For Project-255230, Maint. of Baranda JGY Feeder Under SSVY 2019-20, Scheme:Coastal, WO.699/24-12-19(PO.159557), Cont.: SHRI ASHAPURA ELEC.(Dayapar SD.)
37	Item Code :	103000014	Organization : P95
38	Description :	G I STAY WIRE 7/12 SWG 7/2.5 MM	Subinventory : P9507
39	Unit of Measure:	KG	Initial Onhand Quantity : 33946
40	Period from	19-MAR-20 to 19-MAR-20
41	S.No	Transaction Date	Transaction Type	Req/Move Order No.	Transfer Subinventory	Transaction Quantity	On hand Quantity	Contractor Name	Work Order Number	Sub Work Orde	Description	Supplier	Challan No.	Challan Date	PO No.	Release No	Release Date
42	1	19-Mar-20	Move Order Transfer	23097644	P9502	87	34033				CR.MO. From 3rd.& Final Bill of WO:601/2-3-19, PO.151519, Scheme:Coastal, Cont:SHRI ASHAPURA ELEC. (DYP.SD.)
43	2	19-Mar-20	Move Order Transfer	23107353	P9502	96	34129				CR.MO. From WO.699/24-12-19, PO.159557, Scheme:-SPA, Cont.: SHRI ASHAPURA ELEC. (DYP.SD.)
44	3	19-Mar-20	Issue To Projects	22977062		-21	34108	SHREE ASHAPURA ELECTRICS	159557	3	MO. For Project-255230, Maint. of Baranda JGY Feeder Under SSVY 2019-20, Scheme:Coastal, WO.699/24-12-19(PO.159557), Cont.: SHRI ASHAPURA ELEC.(Dayapar SD.)
45	4	19-Mar-20	Move Order Transfer	23097978	P9502	-279	33829				MO. For SR.12321640/12494719/12471500/12095779/12385287/12321910/12484994/11840582/ 12553994/12544985/12576740/12528992/12553905/12514254/12556240, Scheme:SPA, WO.709/10-2-20, PO.160878, Cont:-Shri Ashapura Elec. (DYP.SD.)
46	5	19-Mar-20	Issue To Projects	23098380		-480	33349	SHREE ASHAPURA ELECTRICS	160878	2	MO. For Project-261412, Maint.of KANER JGY Under SSVY 2019-20, Scheme:Coastal(SSVY), WO:709/10-2-20, PO.160878, Cont:-SHRI ASHAPURA ELEC. (DYP.SD.)
47	6	19-Mar-20	Move Order Transfer	23098531	P9502	-15	33334				MO. For SR.12492304, Manilal Ramji -Dolatpar, Scheme:SPA, WO.601/02-03-19, PO.151519, Cont.: Shri Ashapura Elec. (DYP.SD.)
48	7	19-Mar-20	Move Order Transfer	23099635	P9503	-210	33124				MO. for SR.11599415/12005850/12336396/12277381/12234164/12225229/12393606/12424704/ 11886348/12478257/11805062/12170767, Scheme:SPA, WO.696/20-12-19, PO.159433, Cont: Shri Ashapu6ra Elec.(RVP.SD.)
49	8	19-Mar-20	Issue To Projects	23033924		-60	33064	SHREE ASHAPURA ELECTRICS	159433	3	MO. for Project-267629, Bifurgation of Ghadani Ag.Feeder, Scheme:SKJY, WO.696/20-12-19(PO.159433), Cont: Shri Ashapura Elec.(RVP.SD.)
PASTE MTR

EXAMLE FILE / OUTPUT DATA ARRANGEMENT SHOULD BE LIKE BELOW :

Material_Transaction_Report.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y
1	Sr.	S.No	Helper Column	Item Code	Description	Unit of Measure	Transaction Date	Transaction Type	Req/Move Order No.	Date	GP NO	Initial Onhand Quantity	Transaction Quantity	On hand Quantity	Transfer Subinventory	Contractor Name	Work Order Number	Sub Work Orde	Description	Supplier	Challan No.	Challan Date	PO No.	Release No	Release Date
2	1	1		102000031	ALL ALLUMINIUM ALLOY CONDUCTOR 34 SQMM WEASEL	KM	19-Mar-20	Move Order Transfer	23107353			440.675	3.783	444.458	P9502				CR.MO. From WO.699/24-12-19, PO.159557, Scheme:-SPA, Cont.: SHRI ASHAPURA ELEC. (DYP.SD.)
3	2	2		102000031	ALL ALLUMINIUM ALLOY CONDUCTOR 34 SQMM WEASEL	KM	19-Mar-20	Move Order Transfer	23097978				-12.175	432.283	P9502				MO. For SR.12321640/12494719/12471500/12095779/12385287/12321910/12484994/11840582/ 12553994/12544985/12576740/12528992/12553905/12514254/12556240, Scheme:SPA, WO.709/10-2-20, PO.160878, Cont:-Shri Ashapura Elec. (DYP.SD.)
4	3	3		102000031	ALL ALLUMINIUM ALLOY CONDUCTOR 34 SQMM WEASEL	KM	19-Mar-20	Move Order Transfer	23098531				-0.179	432.104	P9502				MO. For SR.12492304, Manilal Ramji -Dolatpar, Scheme:SPA, WO.601/02-03-19, PO.151519, Cont.: Shri Ashapura Elec. (DYP.SD.)
5	4	4		102000031	ALL ALLUMINIUM ALLOY CONDUCTOR 34 SQMM WEASEL	KM	19-Mar-20	Issue To Projects	23033923				-12.39	419.714		SHREE ASHAPURA ELECTRICS	159433	2	MO. for Project-261169, Maint. of Ghadani Ag. Under SSVY 19-20, Scheme:SKJY, WO.696/20-12-19(PO.159433), Cont: Shri Ashapura Elec.(RVP.SD.)
6	5	1		102000033	ALL ALLUMINIUM ALLOY CNDUCTOR 55 SQMM RABBIT	KM	19-Mar-20	Move Order Transfer	23097644			329.507	5.37	334.877	P9502				CR.MO. From 3rd.& Final Bill of WO:601/2-3-19, PO.151519, Scheme:Coastal, Cont:SHRI ASHAPURA ELEC. (DYP.SD.)
7	6	2		102000033	ALL ALLUMINIUM ALLOY CNDUCTOR 55 SQMM RABBIT	KM	19-Mar-20	Move Order Transfer	23107354				0.149	335.026	P9502				CR.MO. From WO.699/24-12-19, PO.159557, Project-255230, Maint. of Baranda JGY Feeder Under SSVY 2019-20, Scheme:-Coastal, Cont.: SHRI ASHAPURA ELEC. (DYP.SD.)
8	7	3		102000033	ALL ALLUMINIUM ALLOY CNDUCTOR 55 SQMM RABBIT	KM	19-Mar-20	Issue To Projects	23098380				-45.517	289.509		SHREE ASHAPURA ELECTRICS	160878	2	MO. For Project-261412, Maint.of KANER JGY Under SSVY 2019-20, Scheme:Coastal(SSVY), WO:709/10-2-20, PO.160878, Cont:-SHRI ASHAPURA ELEC. (DYP.SD.)
9	8	1		103000002	G I WIRE 8 SWG 4MM	KG	19-Mar-20	Move Order Transfer	23107353			13138.84	40	13178.84	P9502				CR.MO. From WO.699/24-12-19, PO.159557, Scheme:-SPA, Cont.: SHRI ASHAPURA ELEC. (DYP.SD.)
10	9	2		103000002	G I WIRE 8 SWG 4MM	KG	19-Mar-20	Issue To Projects	22977062				-91	13087.84		SHREE ASHAPURA ELECTRICS	159557	3	MO. For Project-255230, Maint. of Baranda JGY Feeder Under SSVY 2019-20, Scheme:Coastal, WO.699/24-12-19(PO.159557), Cont.: SHRI ASHAPURA ELEC.(Dayapar SD.)
11	10	3		103000002	G I WIRE 8 SWG 4MM	KG	19-Mar-20	Move Order Transfer	23097978				-332.5	12755.34	P9502				MO. For SR.12321640/12494719/12471500/12095779/12385287/12321910/12484994/11840582/ 12553994/12544985/12576740/12528992/12553905/12514254/12556240, Scheme:SPA, WO.709/10-2-20, PO.160878, Cont:-Shri Ashapura Elec. (DYP.SD.)
12	11	4		103000002	G I WIRE 8 SWG 4MM	KG	19-Mar-20	Issue To Projects	23098380				-912.5	11842.84		SHREE ASHAPURA ELECTRICS	160878	2	MO. For Project-261412, Maint.of KANER JGY Under SSVY 2019-20, Scheme:Coastal(SSVY), WO:709/10-2-20, PO.160878, Cont:-SHRI ASHAPURA ELEC. (DYP.SD.)
13	12	5		103000002	G I WIRE 8 SWG 4MM	KG	19-Mar-20	Move Order Transfer	23098531				-12.5	11830.34	P9502				MO. For SR.12492304, Manilal Ramji -Dolatpar, Scheme:SPA, WO.601/02-03-19, PO.151519, Cont.: Shri Ashapura Elec. (DYP.SD.)
14	13	6		103000002	G I WIRE 8 SWG 4MM	KG	19-Mar-20	Move Order Transfer	23098599				-22.5	11807.84	P9502				Add.MO. For Project-214561, Dolatpar Ag. Under SSVY, Scheme:Coastal, WO:601/2-3-19, PO.151519, Cont:SHRI ASHAPURA ELEC. NOTE: due to Project date more than 6 month, then linkup MO. "Issue to project" not make in e-urja project module.
15	14	7		103000002	G I WIRE 8 SWG 4MM	KG	19-Mar-20	Move Order Transfer	23099635				-245	11562.84	P9503				MO. for SR.11599415/12005850/12336396/12277381/12234164/12225229/12393606/12424704/ 11886348/12478257/11805062/12170767, Scheme:SPA, WO.696/20-12-19, PO.159433, Cont: Shri Ashapu6ra Elec.(RVP.SD.)
16	15	8		103000002	G I WIRE 8 SWG 4MM	KG	19-Mar-20	Issue To Projects	23033924				-75	11487.84		SHREE ASHAPURA ELECTRICS	159433	3	MO. for Project-267629, Bifurgation of Ghadani Ag.Feeder, Scheme:SKJY, WO.696/20-12-19(PO.159433), Cont: Shri Ashapura Elec.(RVP.SD.)
17	16	1		103000003	G I WIRE 10 SWG 3.15 MM	KG	19-Mar-20	Issue To Projects	22977062			266.5	-266.5	0		SHREE ASHAPURA ELECTRICS	159557	3	MO. For Project-255230, Maint. of Baranda JGY Feeder Under SSVY 2019-20, Scheme:Coastal, WO.699/24-12-19(PO.159557), Cont.: SHRI ASHAPURA ELEC.(Dayapar SD.)
18	17	1		103000014	G I STAY WIRE 7/12 SWG 7/2.5 MM	KG	19-Mar-20	Move Order Transfer	23097644			33946	87	34033	P9502				CR.MO. From 3rd.& Final Bill of WO:601/2-3-19, PO.151519, Scheme:Coastal, Cont:SHRI ASHAPURA ELEC. (DYP.SD.)
19	18	2		103000014	G I STAY WIRE 7/12 SWG 7/2.5 MM	KG	19-Mar-20	Move Order Transfer	23107353				96	34129	P9502				CR.MO. From WO.699/24-12-19, PO.159557, Scheme:-SPA, Cont.: SHRI ASHAPURA ELEC. (DYP.SD.)
20	19	3		103000014	G I STAY WIRE 7/12 SWG 7/2.5 MM	KG	19-Mar-20	Issue To Projects	22977062				-21	34108		SHREE ASHAPURA ELECTRICS	159557	3	MO. For Project-255230, Maint. of Baranda JGY Feeder Under SSVY 2019-20, Scheme:Coastal, WO.699/24-12-19(PO.159557), Cont.: SHRI ASHAPURA ELEC.(Dayapar SD.)
21	20	4		103000014	G I STAY WIRE 7/12 SWG 7/2.5 MM	KG	19-Mar-20	Move Order Transfer	23097978				-279	33829	P9502				MO. For SR.12321640/12494719/12471500/12095779/12385287/12321910/12484994/11840582/ 12553994/12544985/12576740/12528992/12553905/12514254/12556240, Scheme:SPA, WO.709/10-2-20, PO.160878, Cont:-Shri Ashapura Elec. (DYP.SD.)
22	21	5		103000014	G I STAY WIRE 7/12 SWG 7/2.5 MM	KG	19-Mar-20	Issue To Projects	23098380				-480	33349		SHREE ASHAPURA ELECTRICS	160878	2	MO. For Project-261412, Maint.of KANER JGY Under SSVY 2019-20, Scheme:Coastal(SSVY), WO:709/10-2-20, PO.160878, Cont:-SHRI ASHAPURA ELEC. (DYP.SD.)
23	22	6		103000014	G I STAY WIRE 7/12 SWG 7/2.5 MM	KG	19-Mar-20	Move Order Transfer	23098531				-15	33334	P9502				MO. For SR.12492304, Manilal Ramji -Dolatpar, Scheme:SPA, WO.601/02-03-19, PO.151519, Cont.: Shri Ashapura Elec. (DYP.SD.)
24	23	7		103000014	G I STAY WIRE 7/12 SWG 7/2.5 MM	KG	19-Mar-20	Move Order Transfer	23099635				-210	33124	P9503				MO. for SR.11599415/12005850/12336396/12277381/12234164/12225229/12393606/12424704/ 11886348/12478257/11805062/12170767, Scheme:SPA, WO.696/20-12-19, PO.159433, Cont: Shri Ashapu6ra Elec.(RVP.SD.)
25	24	8		103000014	G I STAY WIRE 7/12 SWG 7/2.5 MM	KG	19-Mar-20	Issue To Projects	23033924				-60	33064		SHREE ASHAPURA ELECTRICS	159433	3	MO. for Project-267629, Bifurgation of Ghadani Ag.Feeder, Scheme:SKJY, WO.696/20-12-19(PO.159433), Cont: Shri Ashapura Elec.(RVP.SD.)
MTR IN - OUT

 

[Fluff]

Cross posted Need help to generate desired data in new excel sheet

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

Also in future please do not shout (using all caps).