Hello everyone, new here and of course asking for help.
Please help me find the right answer to one of the tasks to get a new job.
I'd appreciate any input!
Here is the task:
Please separate and sort the following list into excel with the following columns, sorted by category then start date. Please explain the steps (excel formulas or commands) you took to accomplish this.
Start Date Category Ticket Subject
RQ10361 - SEC Add 2017/01/01 Eevee
RQ10195 - SEC Add 2017/01/04 Pen
RQ10197 - SEC Add 2017/01/04 Pencil
Jan 10 RQ10205 - New Strife
RQ10209 - SEC Act 2017/01/10 DEGRANDE
Jan 3 RQ10212 - SEC New Krystal
RQ10223 - SEC Mod 2017/01/04 Blue
RQ10226 - SEC Mod 2017/01/04 Fowlis
RQ10230 - Sec Add 2017/01/04 John
RQ10245 - SEC Add 2017/01/04 Clement
RQ10245 - SEC Add 2017/01/04 DeVito
RQ10250 - SEC Add 2017/01/04 Kyri
RQ10255 - SEC Add 2017/01/04 Kane
RQ10261 - Sec Add 2017/01/04 Bell
Jan 4 RQ10263 - Pract Student Pyre
RQ10290 - SEC Mod 2017/01/03 Salonga
RQ10291 - SEC Mod 2017/01/03 Bob
RQ10298 - SEC Mod 2017/01/02 Knight
RQ10301 - SEC Add 2017/01/03 Lansbury
RQ10306 - Sec MOD 2017/01/01 Mandy
RQ10313 - SEC Add 2017/01/04 Conrad
RQ10317 - SEC Add 2017/01/02 Wolfram
RQ10319 - SEC Add 2017/01/02 Van Beil
RQ10323 - SEC Add 2017/01/02 Cara
RQ10326 - SEC Add 2017/01/02 Dole
RQ10330 - Sec Add 2017/01/02 Johnson
RQ10330 - Sec Del 2017/01/02 Dwayne
RQ10335 - SEC Add 2017/01/03 Moore
RQ10356 - SEC Add 2017/01/03 Collins
RQ10360 - SEC Del 2017/01/01 Woong
RQ10360 - SEC Mod 2017/01/01 Maiz
RQ10361 - SEC Add 2017/01/01 Cookie
RQ10361 - SEC Act 2017/01/01 Noctis
RQ10362 - SEC Mod 2017/01/05 Maxwel
RQ10365 - New 2017/01/03 Wang
RQ10365 - New 2017/01/05 Back
RQ10367 - Add 2017/01/03 Maiko
RQ10370 - Add 2017/01/03 Bert
RQ10370 - Del 2017/01/03 Artemis
RQ10379 - Add 2017/01/03 Grief
RQ10421 - SEC Del 2017/01/03 Smith
RQ10461 - SEC Mod 2017/01/01 Mika
Bookmarks