Hello
The first screen shot is what Im having. The desired result is also below. Please advice. Also I dont know why nbsp is coming. They are supposed to be blank fields.
Result needed is
The first screen shot is what Im having. The desired result is also below. Please advice. Also I dont know why nbsp is coming. They are supposed to be blank fields.
Book1.xls | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | Id | Name | Location | address | state | Siteno | phone | Fax | ||
2 | 10001 | John | BuildingA | 1WestAve | NY | SITE00001 | (000)999-2222 | |||
3 | 10001 | John | BuildingA | 1WestAve | NY | SITE00001 | (111)222-4444 | |||
4 | 10002 | peter | BuildingB | 13KarelAvenue | NY | SITE00720 | (111)222-3333 | |||
5 | 10002 | peter | BuildingB | 13KarelAvenue | NY | SITE00720 | (111)384-2000 | |||
Sheet3 |
Result needed is
Book1.xls | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
2 | Id | Name | Location | address | state | Siteno | phone | Fax | ||
3 | 10001 | John | BuildingA | 1WestAve | NY | SITE00001 | (000)999-2222 | (111)222-4444 | ||
4 | 10002 | peter | BuildingB | 13KarelAvenue | NY | SITE00720 | (111)222-3333 | (111)384-2000 | ||
Sheet2 |