Formatting excel data
I have an Excel sheet with with below format:
In this Excel, column 1,2 and 3 remains common, and the data which i am suppose to send is in below output csv format:
Output:
QWE;1234;567890;1111;20212021 (Row 1: Column 1,2 and 3 is common with fields columns starting with ‘A’)
QWE;1234;567890;2020 (Row 1: Column 1,2 and 3 is common with fields columns starting with ‘B’)
QWE;1234;567890; ; ; (Row 1: Column 1,2 and 3 is common with fields columns starting with ‘C’)
QWE;1234;567890;1 (Row 1: Column 1,2 and 3 is common with fields columns starting with ‘D’)
QWE;1234;567890;2 (Row 1: Column 1,2 and 3 is common with fields columns starting with ‘E’)
OPI;5678;98765;2222;100100 (Row 2: Column 1,2 and 3 is common with fields columns starting with ‘A’)
OPI;5678;98765;456 (Row 2: Column 1,2 and 3 is common with fields columns starting with ‘B’)
OPI;5678;98765; ;65 (Row 2: Column 1,2 and 3 is common with fields columns starting with ‘C’)
OPI;5678;98765;3 (Row 2: Column 1,2 and 3 is common with fields columns starting with ‘D’)
OPI;5678;98765; ; (Row 2: Column 1,2 and 3 is common with fields columns starting with ‘E’)
Output SS:
Can anyone help me here to resolve the complexity?