Hi all, I would like to insert the description from row above into adjacent cell below in col."B" and then to hide the rows which have the same code in col."A" Please see below the sch. 1. are the original data and in sch.2. is the expected result. Thanking you in advance
Sch.1.
<tbody>
</tbody>
Sch.2.
<tbody>
</tbody>
Sch.1.
A | B | |
1 | Code | Description |
2 | 7800005 | TOURIST |
3 | 7800005 | TOURIST |
4 | 7800005 | TOURIST |
5 | 7800005 Total | |
6 | 7800048 | CONFERENCES |
7 | 7800048 | CONFERENCES |
8 | 7800048 | CONFERENCES |
9 | 7800048 | CONFERENCES |
10 | 7800048 | CONFERENCES |
11 | 7800052 Total | |
12 | 7800077 | WEDDINGS |
13 | 7800077 | WEDDINGS |
14 | 7800077 | WEDDINGS |
15 | 7800077 Total |
<tbody>
</tbody>
Sch.2.
A | B | |
1 | Code | Description |
5 | 7800005 Total | TOURIST |
11 | 7800052 Total | CONFERENCES |
15 | 7800077 Total | WEDDINGS |
<tbody>
</tbody>
Last edited: