alexgoodwill
New Member
- Joined
- Dec 11, 2011
- Messages
- 23
Hi,
I have 100 groups of data in a single column. I will list the below example using 3 groups.
A1
B1
C1
A2
B2
C2
A3
B3
C3
I would like to transpose them into a single row for each group, the output will be :
A1 B1 C1
A2 B2 C2
A3 B3 C3
I can use copy as transpose when I do each group individually but it will take a long time. Is there any way to do it with a formula?
Cheers!
I have 100 groups of data in a single column. I will list the below example using 3 groups.
A1
B1
C1
A2
B2
C2
A3
B3
C3
I would like to transpose them into a single row for each group, the output will be :
A1 B1 C1
A2 B2 C2
A3 B3 C3
I can use copy as transpose when I do each group individually but it will take a long time. Is there any way to do it with a formula?
Cheers!