Import data in Excel, then order first by name, then date of creation, and at the end order by user login.
At next free column, at the second row add this formula ( =IF(A2<>A1;C2;"") ) and then apply this formula to entire column by dragging or using ctrl+shift+end and ctrl+d.
In my version of Excel, the formula needs commas, not semicolons:
=IF(A2<>A1, C2,“”)
Also, I think the C145 was probably just from the cell you grabbed, but if you’re setting it up in the second row ought to be C2.
Also, just to be clear, sequence the columns (left to right) as described and sort them A->Z.
Thanks, you are correct, it is C2, like its shown on first photo.
I probably grab formula from 145 row, and then forget to edit this :)
I corrected that now.
You are also correct for delimiters, that time I used Open Office which use commas, and in Excel there must be semicolons.
I have two different computers, one with Windows and other with Linux so sometimes I mix things up.