Hi Team,
I want to convert data in matrix format into tabular (database) format. Please suggest technical way to handle it. currently, I have to do copy & paste data to populate data in table (database format). Will be grateful. Thanks & Regards. Nishchint.
INPUT DATA
Article Article Description Site 1 Site 2 Site 3 Site 4 108020365 BRITANNIA BISC 50 50 113G 231 8 5 7 108020368 BRITANNIA BISC 50*50 FP 151g 335 15 20 15 108020392 BRITANNIA BISC DIGESTIVE 100G 167 10 10 5 108020402 BRITANNIA BISC GDAY PISTA 185G 405 23 10 24 108020419 BRITANNIA BISC NICE TIME 160G 545 25 20 36 108020432 BRITANNIA BISC TIGER 61.5G 1269 53 100 70
REQUIRED OUT PUT DATA
SITE NAME Article Article Description TARGET STOCK SITE 1 108020365 BRITANNIA BISC 50 50 113G 231 SITE 1 108020368 BRITANNIA BISC 50*50 FP 151g 335 SITE 1 108020392 BRITANNIA BISC DIGESTIVE 100G 167 SITE 1 108020402 BRITANNIA BISC GDAY PISTA 185G 405 SITE 1 108020419 BRITANNIA BISC NICE TIME 160G 545 SITE 1 108020432 BRITANNIA BISC TIGER 61.5G 1269 SITE 2 108020365 BRITANNIA BISC 50 50 113G 8 SITE 2 108020368 BRITANNIA BISC 50*50 FP 151g 15 SITE 2 108020392 BRITANNIA BISC DIGESTIVE 100G 10 SITE 2 108020402 BRITANNIA BISC GDAY PISTA 185G 23 SITE 2 108020419 BRITANNIA BISC NICE TIME 160G 25 SITE 2 108020432 BRITANNIA BISC TIGER 61.5G 53 SITE 3 108020365 BRITANNIA BISC 50 50 113G 5 SITE 3 108020368 BRITANNIA BISC 50*50 FP 151g 20 SITE 3 108020392 BRITANNIA BISC DIGESTIVE 100G 10 SITE 3 108020402 BRITANNIA BISC GDAY PISTA 185G 10 SITE 3 108020419 BRITANNIA BISC NICE TIME 160G 20 SITE 3 108020432 BRITANNIA BISC TIGER 61.5G 100 SITE 4 108020365 BRITANNIA BISC 50 50 113G 7 SITE 4 108020368 BRITANNIA BISC 50*50 FP 151g 15 SITE 4 108020392 BRITANNIA BISC DIGESTIVE 100G 5 SITE 4 108020402 BRITANNIA BISC GDAY PISTA 185G 24 SITE 4 108020419 BRITANNIA BISC NICE TIME 160G 36 SITE 4 108020432 BRITANNIA BISC TIGER 61.5G 70
Bookmarks