Clive Southon
New Member
- Joined
- Apr 25, 2013
- Messages
- 8
Hello there.
I need help with a lookup matter.
My efforts to use INDEX and MATCH have not worked.
A system generated report is received is in columns and looks like this:
Ticket ID Type Measure Oct 2019 Overall Result
7004114394 Amount Finalized H 1.00 1.00
7004114394 Average Author Action Time H
I need help with a lookup matter.
My efforts to use INDEX and MATCH have not worked.
A system generated report is received is in columns and looks like this:
Ticket ID Type Measure Oct 2019 Overall Result
7004114394 Amount Finalized H 1.00 1.00
7004114394 Average Author Action Time H
0.00 0.00
7004114394 Average Waiting Time H 0.48 0.48
7004114394 Average Process Time H 2058.60 2058.60
7004114394 Average End-to-End Duration H 2059.07 2059.07
7004114394 Average Lifecycle Time H
7004172682 7004114394 Average Lifecycle Time H
2059.07 2059.07
Amount Finalized H
7004172682 1.00 1.00
Average Author Action Time H
7004172682 0.00 0.00
Average Waiting Time H
7004172682 3.75 3.75
Average Process Time H
7004172682 698.07 698.07
Average End-to-End Duration H
7004172682 885.40 885.40
Average Lifecycle Time H
1253.37 1253.37
I need to put each Ticket Number, with the different headings in a row so each row is unique.
NOTE: I have only used TWO of the Ticket numbers - there could be a hundred.
Thanks in advance.
I need to put each Ticket Number, with the different headings in a row so each row is unique.
NOTE: I have only used TWO of the Ticket numbers - there could be a hundred.
Thanks in advance.