I have this data in sheet1
and the result in sheet2
so the result should be in COL A,D based on fill data in col B, . it should match with COL A in sheet 1 then shoud autonumber and repeat the values for each repeated item
7.xlsx | ||||
---|---|---|---|---|
A | B | |||
1 | CODE | VALUE | ||
2 | A-1000 | 1000 | ||
3 | A-1001 | 1001 | ||
4 | A-1002 | 1002 | ||
5 | A-1003 | 1003 | ||
6 | A-1004 | 1004 | ||
7 | A-1005 | 1005 | ||
8 | A-1006 | 1006 | ||
9 | A-1007 | 1007 | ||
10 | A-1008 | 1008 | ||
SHEET1 |
and the result in sheet2
7.xlsx | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | S.N | ITEM | DATE | VALUE | ||
2 | 1 | A-1000 | 1/1/2021 | 1000 | ||
3 | 1 | A-1000 | 1/2/2021 | 1000 | ||
4 | 1 | A-1000 | 1/3/2021 | 1000 | ||
5 | 2 | A-1001 | 1/4/2021 | 1001 | ||
6 | 2 | A-1001 | 1/5/2021 | 1001 | ||
7 | 2 | A-1001 | 1/6/2021 | 1001 | ||
SHEET2 |
so the result should be in COL A,D based on fill data in col B, . it should match with COL A in sheet 1 then shoud autonumber and repeat the values for each repeated item