edinburgh
2014-02-05, 07:51 AM
Site
AZ1
AZ2
AZ3
Height
Address
Site001
0
120
240
55
Address1
Site002
10
100
250
40
Address2
Site003
12
100
300
45
Address3
Site004
15
140
blank
20
Address4
Site005
18
136
300
35
Address5
The table above is what I have.
The table below is what I would need macro to transpose:
Site
AZ
Height
Address
Site001
0
55
Address1
Site001
120
55
Address1
Site001
240
55
Address1
Site002
10
40
Address2
Site002
100
40
Address2
Site002
250
40
Address2
Site003
12
45
Address3
Site003
100
45
Address3
Site003
300
45
Address3
Site004
15
20
Address4
Site004
140
20
Address4
Site005
18
35
Address5
Site005
136
35
Address5
Site005
300
35
Address5
But here Site 004 has only 2 AZ and it should be copy/make only 2 rows.
Hello Experts, Please kindly help me to get maco for Excel 2007.
Thanks.
BR//
Edin
AZ1
AZ2
AZ3
Height
Address
Site001
0
120
240
55
Address1
Site002
10
100
250
40
Address2
Site003
12
100
300
45
Address3
Site004
15
140
blank
20
Address4
Site005
18
136
300
35
Address5
The table above is what I have.
The table below is what I would need macro to transpose:
Site
AZ
Height
Address
Site001
0
55
Address1
Site001
120
55
Address1
Site001
240
55
Address1
Site002
10
40
Address2
Site002
100
40
Address2
Site002
250
40
Address2
Site003
12
45
Address3
Site003
100
45
Address3
Site003
300
45
Address3
Site004
15
20
Address4
Site004
140
20
Address4
Site005
18
35
Address5
Site005
136
35
Address5
Site005
300
35
Address5
But here Site 004 has only 2 AZ and it should be copy/make only 2 rows.
Hello Experts, Please kindly help me to get maco for Excel 2007.
Thanks.
BR//
Edin