Data Segregation and Cleaning

[dkma]

Hello all

Can any one please help me in cleaning and Segregating the data into a structured format.

Thank you v much in advance

[CarliE]

Hi! 

What are you trying to structure it like? something like this? Can u give an example on how you would want it to look?

[dkma]

Hello @CarliE ,

i was able to do that, If you could help me in getting the data in the format

Employee ID

Login

Name

Supervisor

Location

Date

OT Amount

OT Type

If it includes null values with all the dates. that would be great

[CarliE · Accepted solution]

Attached is the workflow.

Please mark this as a solution if you found it helpful. If it isn't what you are looking for, please let me know!

Thanks!

[dkma]

You are awesome Carli

[CarliE]

No problem at all! 🙂 

[dkma]

Hey @CarliE    

Attached is my sample data with multiple employee IDs.

is the process same as below for the attached sheet