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.
