Hi,
I am trying to see how to multiple columns into one where this data:
Inq | Transfer | Apps |
3 | 0 | 0 |
3 | 2 | 3 |
1 | 0 | 0 |
1 | 0 | 0 |
2 | 2 | 2 |
2 | 1 | 2 |
1 | 1 | 0 |
1 | 0 | 1 |
7 | 2 | 0 |
18 | 14 | 17 |
turns into
Metric | Value |
Inq | 3 |
Inq | 3 |
Inq | 1 |
Inq | 1 |
Inq | 2 |
Inq | 2 |
Inq | 1 |
Inq | 1 |
Inq | 7 |
Inq | 18 |
Transfer | 0 |
Transfer | 2 |
Transfer | 0 |
Transfer | 0 |
Transfer | 2 |
Transfer | 1 |
Transfer | 1 |
Transfer | 0 |
Transfer | 2 |
Transfer | 14 |
Apps | 0 |
Apps | 3 |
Apps | 0 |
Apps | 0 |
Apps | 2 |
Apps | 2 |
Apps | 0 |
Apps | 1 |
Apps | 0 |
Apps | 17 |
@bryanmac_92
A Transpose tool does the exact you need here.
I have added a small technique to get the data order as in your sample output.
User | Count |
---|---|
52 | |
27 | |
25 | |
24 | |
21 |