funkdoctaspock
New Member
- Joined
- Jan 22, 2018
- Messages
- 3
Good Evening, I have a export file for work that will export employee shifts by job code. In column A of the file there will be ~ 500 rows. I think what I am trying to achieve can be best explained as: I will have repeating values in column A (employee name like Dave, Tom etc etc.) It is only necessary to keep the first instance of the employee's name in column A. In columns B-H (days of the week) employees will have different jobs assigned (not included on the export / not important for this exercise). Complicating things would be that Dave could have 4 different job codes each of which would show in a different row. I will need to group all values in columns B:H into the first row (with the employee's name) so that they may read a proper work schedule when posted. Currently I cannot post a dummy file for an example - but does anyone have any good suggestions on how to accomplish this? I have searched quite a bit and nothing is jumping out at me. What I can paste into this post looks like this - MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY SATURDAY SUNDAY DAVE 8-5 7-3 DAVE 8-5 8-5 8-5 DAVE 7-3 7-3 DAVE I would like it to read Dave 8-5 7-3 (I think you get the picture) Any help would be greatly appreciated - VBA is ok too. Thanks for reading!