Hi,
I have excel data as under, is it possible to copy horizontal data vertically as shown below?
<tbody>
</tbody>
<tbody>
</tbody>and so on....
The data beyond column D for that particular EmpID gets copied just above the next EmplID.
Is it even possible to do this?
I have excel data as under, is it possible to copy horizontal data vertically as shown below?
A | B | C | D | E | F | G | |
1 | EmpID | 123 | |||||
2 | 1111 | 2222 | 3333 | 3333 | 2222 | 1111 | |
3 | 5555 | 6666 | 4444 | 2222 | 7777 | 1111 | |
4 | 4444 | 9999 | 8888 | 555 | 56 | 468 | |
5 | EmpID | 124 | |||||
6 | 111 | 223 | 125 | 45452 | 45454 | 454 | |
7 | 1234 | 5684 | 5689 | 5354 | 697 | 359 | |
8 | EmpID | 125 | |||||
9 | 1246 | 2685 | 6564 | 4789 | 665 | 567 | |
10 |
<tbody>
</tbody>
Result | A | B | C | D | E |
1 | EmpID | 123 | |||
2 | 1111 | 2222 | 3333 | ||
3 | 5555 | 6666 | 4444 | ||
4 | 4444 | 9999 | 8888 | ||
5 | |||||
6 | 3333 | 2222 | 1111 | ||
7 | 2222 | 7777 | 1111 | ||
8 | 555 | 56 | 468 | ||
9 | EmpID | 124 | |||
10 | 111 | 223 | 125 | ||
11 | 1234 | 5684 | 5689 | ||
12 | |||||
13 | 45452 | 45454 | 454 | ||
14 | 5354 | 697 | 359 |
<tbody>
</tbody>
The data beyond column D for that particular EmpID gets copied just above the next EmplID.
Is it even possible to do this?