this will be a major help but i'm not sure if anybody can help me. I have a massive data sheet that i would like to sort out. I dump the raw data on sheet two and would like to type in the item i want to see the history on in sheet one. example below sheet two then sheet one.
<tbody>
</tbody>
<tbody>
</tbody>
ticket id | priority | date of service | vehicle id | user name | department | status | problem | corrective action | service date | comments | compliance |
1 | no | 5/1/19 | 3201 | robert | southern | completed | tires | replaced tires | 5/1/19 | ||
2 | yes | 5/2/19 | 2200 | bob | western | active | piston 4 | n/a | n/a | ||
3 | no | 5/2/19 | 2200 | bob | western | completed | tires | replaced tires | 5/2/19 | ||
4 | no | 5/2/19 | 2200 | bob | western | completed | oil change | replaced oil | 5/2/19 |
<tbody>
</tbody>
2200 | |||||||||||
ticket id | priority | date of service | user name | department | status | problem | corrective action | service date | comments | compliance | |
2 | yes | 5/2/19 | bob | western | active | piston 4 | n/a | n/a | |||
3 | no | 5/2/19 | bob | western | completed | tires | replaced tires | 5/2/19 | |||
4 | no | 5/2/19 | bob | western | completed | oil change | replaced oil | 5/2/19 | |||
<tbody>
</tbody>