I am trying to manage time sheet of my company and have a small issue. I have data ordered in rows per person, however I would like to have them in column format. Currently, data is in following format:
I would like it to have the following shape:
Rules that are to be followed: withing the same name(person) and same date, take the "OUT" time value and put it to the next row. Please note that there are few thousand rows.
Questions are very welcome Many thanks in advance!
I would like it to have the following shape:
Rules that are to be followed: withing the same name(person) and same date, take the "OUT" time value and put it to the next row. Please note that there are few thousand rows.
Questions are very welcome Many thanks in advance!