I've searched for several hours but can't find anything that matches exactly what I'm looking to do. I have a dataframe that looks like this:
| Company | Field 1 | Field 2 | Field 3 |
|---|---|---|---|
| Walmart | 5 | 10 | 15 |
| Target | 7 | 4 | 37 |
| Kohl's | 3 | 11 | 9 |
I want the alter the row fields to be column, like this:
| Company | Score |
|---|---|
| Walmart | 5 |
| Walmart | 10 |
| Walmart | 15 |
| Target | 7 |
| Target | 4 |
| Target | 37 |
| Kohl's | 3 |
| Kohl's | 11 |
| Kohl's | 9 |
I'm sure there's an easy way to do this, but I haven't found it yet. I've tried pivoting and a few other things, but it hasn't worked for me.
Any assistance would be greatly appreciated.
Thanks.
