Vishaal
Well-known Member
- Joined
- Mar 16, 2019
- Messages
- 533
- Office Version
- 2010
- 2007
- Platform
- Windows
- Web
HI, we want to filter data from two column to one as per result sheet
(Excel 2007 and Excel 2010)
Result Sheet
(Excel 2007 and Excel 2010)
Book1 | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | S.No. | Barc | Second | ||
2 | 1 | ||||
3 | 2 | SQ351 | |||
4 | 3 | SQ352 | |||
5 | 4 | SQ353 | |||
6 | 5 | SQ354 | |||
7 | 6 | SQ354 - 1 | |||
8 | 7 | SQ358 | |||
9 | 8 | SQ354 | |||
10 | 9 | SQ354 - 2 | |||
11 | 10 | SQ354 - 3 | |||
12 | 11 | SQ357 | |||
Sheet1 |
Result Sheet
Book1 | |||
---|---|---|---|
A | |||
20 | Final | ||
21 | SQ351 | ||
22 | SQ352 | ||
23 | SQ353 | ||
24 | SQ354 | ||
25 | SQ354 - 1 | ||
26 | SQ354 - 2 | ||
27 | SQ354 - 3 | ||
28 | SQ357 | ||
29 | SQ358 | ||
Sheet1 |