Hello,
I would love o get some help with this problem, since it was quite some time i used excel for more than summing things up.
So - I've got a table with about 1000 rows, and four columns.
The first column has the ID of a place.
The second column has the name of that place
The second column has a date of when the place was inspected
The third column has the 0-5 verdict of the place
The problem is that each place are inspected various times so that some places have been inspected 4 times, and some 0.
This means that the table might look something like this:
<tbody>
</tbody>
I need to get the last three times the places were inspected, what date and verdict laid out in columns, how do I do that?
How do I get that table to look like this:
<tbody>
</tbody>
Thanks for any help.
I would love o get some help with this problem, since it was quite some time i used excel for more than summing things up.
So - I've got a table with about 1000 rows, and four columns.
The first column has the ID of a place.
The second column has the name of that place
The second column has a date of when the place was inspected
The third column has the 0-5 verdict of the place
The problem is that each place are inspected various times so that some places have been inspected 4 times, and some 0.
This means that the table might look something like this:
Place | Name | Date | Verdict |
521 | First place | 2015.02.20 | 3 |
521 | First place | 2016.01.15 | 3 |
521 | First place | 2017.03.01 | 4 |
622 | Second place | 2014.02.10 | 2 |
622 | Second place | 2017.01.10 | 4 |
723 | Third place | 2016.08.10 | 1 |
<tbody>
</tbody>
I need to get the last three times the places were inspected, what date and verdict laid out in columns, how do I do that?
How do I get that table to look like this:
Place | Name | 1st | Verdict | 2nd | Verdict | 3rd | Verdict |
521 | First Place | 2015.02.20 | 3 | 2016.01.15 | 3 | 2017.03.01 | 4 |
622 | Second Place | 2014.02.10 | 2 | 2017.01.10 | 4 | ||
723 | Third Place | 2016.08.10 | 1 |
<tbody>
</tbody>
Thanks for any help.