samlim1014
New Member
- Joined
- Feb 1, 2019
- Messages
- 1
Hi everyone,
I have a data set like the following.
Unfortunately, my data is a lot more complex than this so a simple Pivot won't let me analyse it
<tbody>
</tbody>
How can I show in the first Column that John liked Apples in 2016 and 2017. I don't mind concatenations eg 2016Apples2017Apples; just can't seem to figure out how. :/
Hope this makes sense. Thank you.
I have a data set like the following.
Unfortunately, my data is a lot more complex than this so a simple Pivot won't let me analyse it
Name/Year | Apples? | 2016 | 2017 | 2018 |
John | Apples | Apples | Oranges | |
Emma | Apples | Apples | Apples | |
Dave | Oranges | Apples | Oranges |
<tbody>
</tbody>
How can I show in the first Column that John liked Apples in 2016 and 2017. I don't mind concatenations eg 2016Apples2017Apples; just can't seem to figure out how. :/
Hope this makes sense. Thank you.