Transpose and link Multicolum matrix in 2 colum array
Hi
I have a matrix of the format
ny chicago beijing ...
manager 1 2 3
staff 101 200 300
Volunteer 102 202 302
and I want to link it to a single column data
manager ny 1
staff ny 101
Volunteer ny 102
manager chicago 2
staff chicago 200
Volunteer chicago 202
where the 2nd table is linked to the first and whenever the data changes it
in the first it changes also in the second
|