Hello all,
my data comes in like this
| Base | Question | ID |
| What color | Red | 1 |
| What cost | $5.00 | 1 |
| What color | Blue | 2 |
| What cost | $4.00 | 2 |
However I want it to look like this for easier usability
| ID | What Color | What Cost |
| 1 | Red | $5.00 |
| 2 | Blue | $4.00 |
the Base and Question columns repeat and are the same for all of the ID values.
Thank you in advance!