Matrix modifications

Hi,

I would like without using vba is possible, to modify a matrix from:

			
		201503	201504	201505	201506
varA	index1	15	18	800	18
	index2	12	18	18	18
varB	index1	230	225	225	225
	index2	230	225	225	225
varC	index1	13	13	13	13
	index2	13	13	17	13

to :

var A 	201503	index1	15
var A 	201504	index1	18
var A 	201505	index1	800
var A 	201506	index1	18
var A 	201503	index2	12
var A 	201504	index2	18
var A 	201505	index2	18
var A 	201506	index2	18
varB	201503	index1	230
varB	201504	index1	225
varB	201505	index1	225
varB	201506	index1	225
varB	201503	index2	230
varB	201504	index2	225
varB	201505	index2	225
varB	201506	index2	225
varC	201503	index1	13
varC	201504	index1	13
varC	201505	index1	13
varC	201506	index1	13
varC	201503	index2	13
varC	201504	index2	13
varC	201505	index2	17
varC	201506	index2	13

I tried to figure out a simple way to do this but without any success.

please any help ?

Clement

Welcome to the board.

	A	B	C	D	E	F	G
1			201503	201504	201505	201506
2	varA	index1	15	18	800	18
3		index2	12	18	18	18
4	varB	index1	230	225	225	225
5		index2	230	225	225	225
6	varC	index1	13	13	13	13
7		index2	13	13	17	13
8
9
10	row
11	0	varA	201503	index1	15		B11: =INDEX($A$2:$A$6, 2 * INT($A11/8) + 1)
12	1	varA	201504	index1	18		C11: =INDEX($C$1:$F$1, MOD($A11, 4) + 1)
13	2	varA	201505	index1	800		D11: =INDEX($B$2:$B$7, INT($A11/4) + 1)
14	3	varA	201506	index1	18		E11: =INDEX($C$2:$F$7, INT($A11/4) + 1, MOD($A11, 4) + 1)
15	4	varA	201503	index2	12
16	5	varA	201504	index2	18
17	6	varA	201505	index2	18
18	7	varA	201506	index2	18
19	8	varB	201503	index1	230
20	9	varB	201504	index1	225
21	10	varB	201505	index1	225
22	11	varB	201506	index1	225
23	12	varB	201503	index2	230
24	13	varB	201504	index2	225
25	14	varB	201505	index2	225
26	15	varB	201506	index2	225
27	16	varC	201503	index1	13
28	17	varC	201504	index1	13
29	18	varC	201505	index1	13
30	19	varC	201506	index1	13
31	20	varC	201503	index2	13
32	21	varC	201504	index2	13
33	22	varC	201505	index2	17
34	23	varC	201506	index2	13