My internal table ITAB contains two columns NODE and VALUE.
The contents are as follows
NODE VALUE
A 1
B 2
C 3
D 4
E 5
F 6
D 7
E 8
F 9
G 10
H 11
I 12
G 13
H 14
I 15
G 16
H 17
I 18
J 19
K 20
L 21
J 22
K 23
L 24
My requirement is I need to move the values to JTAB such that JTAB should have columns as D E F and should be having the following values filled in the columns.
JTAB
D E F
4 5 6
7 8 9
Similarly I need to move the values to KTAB such that KTAB should have columns as G H I and should be having the following values filled in the columns.
KTAB
G H I
10 11 12
13 14 15
16 17 18
Similarly I need to move the values to NTAB such that NTAB should have columns as G H I and should be having the following values filled in the columns.
NTAB
J K L
19 20 21
22 23 24
Please help. Any help is higly appreciated. if dont want to put several if conditions as it will effect performance. is there a simple way to do this