hello
I have data begins from col I to last col is filled . every time I add a new data to the bottom or next column .
orginal data
the result when open the file should show message like this
I have data begins from col I to last col is filled . every time I add a new data to the bottom or next column .
orginal data
1.xlsx | |||||||
---|---|---|---|---|---|---|---|
I | J | K | L | M | |||
3 | ID | OI-44 | ID | OI-41 | |||
4 | BRAND | Q8 | BRAND | Q8 | |||
5 | TYPE | 4×1L | TYPE | 4×4L | |||
6 | IMPORT | 100 | IMPORT | 200 | |||
7 | EXPORT | 50 | EXPORT | 150 | |||
8 | BALANCE | 50 | BALANCE | 50 | |||
9 | |||||||
10 | |||||||
11 | |||||||
12 | |||||||
13 | ID | OI-45 | ID | OI-46 | |||
14 | BRAND | ENI | BRAND | CAS | |||
15 | TYPE | 4×1L | TYPE | 4×4L | |||
16 | IMPORT | 10 | IMPORT | 200 | |||
17 | EXPORT | 10 | EXPORT | 150 | |||
18 | BALANCE | 0 | BALANCE | 50 | |||
1 |
the result when open the file should show message like this
item | ID | BRAND | TYPE | IMPORT | EXPORT | BALANCE |
1 | OI-41 | Q8 | 4×4L | 200 | 150 | 50 |
2 | OI-44 | Q8 | 4×1L | 100 | 50 | 50 |
3 | OI-45 | ENI | 4×1L | 10 | 10 | 0 |
4 | OI-46 | CAS | 4×4L | 200 | 150 | 50 |