How do I transpose as shown below?
I have to columns of data, Site number and Disc number. I have sorted by unique site number but I don't know how to transpose the data.
I have to columns of data, Site number and Disc number. I have sorted by unique site number but I don't know how to transpose the data.
testing.xls | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | Site | Disc | ||||||
2 | 101 | 23 | ||||||
3 | 101 | 24 | ||||||
4 | 101 | 222 | ||||||
5 | 103 | 111 | ||||||
6 | 109 | 125 | ||||||
7 | 109 | 126 | ||||||
8 | 109 | 129 | ||||||
9 | 109 | 189 | ||||||
10 | 109 | 222 | ||||||
11 | ||||||||
12 | ||||||||
13 | Site | Disc1 | Disc2 | Disc3 | Disc4 | Disc5 | ||
14 | 101 | 23 | 24 | 222 | ||||
15 | 103 | 111 | ||||||
16 | 109 | 125 | 126 | 129 | 189 | 222 | ||
Sheet1 |