Hello,
I need a macro to convert row to columns. My data like below
Forest:A
Tree:A
Tree:B
Tree:C
Forest:B
Tree:A
Tree:B
Tree:C
Tree:D
Forest:z1
Forest:1
Tree:1
Tree:2
Tree:5
Tree:10
Tree:15
Forest:X
Tree:A
Tree:1
Tree:Z
Tree:33
Forest:20
Tree:A
I want this data in the spread to be converted into columns like below.
Forest Tree Tree Tree Tree Tree
A A B C
B A B C D
z1
1 1 2 5 10 15
X A 1 Z 33
20 A
Any help is greatly appriciated. Thanks in advance.
Lavan
I need a macro to convert row to columns. My data like below
Forest:A
Tree:A
Tree:B
Tree:C
Forest:B
Tree:A
Tree:B
Tree:C
Tree:D
Forest:z1
Forest:1
Tree:1
Tree:2
Tree:5
Tree:10
Tree:15
Forest:X
Tree:A
Tree:1
Tree:Z
Tree:33
Forest:20
Tree:A
I want this data in the spread to be converted into columns like below.
Forest Tree Tree Tree Tree Tree
A A B C
B A B C D
z1
1 1 2 5 10 15
X A 1 Z 33
20 A
Any help is greatly appriciated. Thanks in advance.
Lavan