Hello,
I am looking for help to transform data which I load from a CSV from:
| Project ID | Question | Answer |
|---|
| 1 | Tooling Solution | ITRS |
| 1 | Current Task Time (mins) | 10 |
| 1 | Current Task Frequency | Daily |
| 1 | Started? | Yes |
| 2 | Tooling Solution | RBA |
| 2 | Current Task Time | 20 |
| 2 | Current Task Frequency | Weekly |
| 2 | Started? | No |
I was hoping to load in the data like so:
| Project ID | Tooling Solution | Current Task time (mins) | Current Task Frequency | Started? |
|---|
| 1 | ITRS | 10 | Daily | Yes |
| 2 | RBA | 20 | Weekly | No |
The reason I want to do this is because I have another table with the project ID and other details on the project (1 row per project ID). I want to get all of the question and answers on to one row too - I was trying this with an expression:
=if([Question]='Tooling Decision:',[Answer])
and then in next field "=if([Question]='Current Task Time (mins)',[Answer])"
for example... this was then giving me 2 rows per project ID (So with above data it would have 4 rows per project - in reality i have 8 questions)
Hope this makes sense!!
Thanks,
Lizi
