|hey, i'm a begginer and I have a row that contains data from a job we did. the last few columns are the workers involved, so I have a column Installer 1, Installer 2 and Installer 3. We can have 1, 2 or 3 of them depending on the job and will be like this:|
TO-NB-NB Only 1 worker, Tomo. (NB=Nobody)
TO-ST-NB Two workers, Tomo and Steve
MK-ST-TO 3 guys, Mike Tomo and Steve
I've extracted the 3 names into individual cells, so now I need to create an entry (row) for each person. So if 2 or more installers, we need to copy that row once for 2 inst. or twice if 3 workers.
BUT, I'd also need to leave only one name of installer per row, so when I add the hours worked on row 1, as there were 2 guys out, I'll have 2 hours as result. But if I leave both names on both rows, the result will be 4...
Did I explain myself??
Thanks for your help in advance!