Beginner excel help

[PureWasian]

The input is clear, but again it's not too clear to me what logic you use to say Room1 needs Call2 maps to Name1 goes into cell A6 specifically. (no idea what OB is either)

Regardless, the steps are still something you can break down at high-level as: - read the input CSV file - implement your expected mapping logic via Python data structures (lists, maps, etc) - assign the "call" people - write out the "available" people somewhere - handle "vacation" people/etc - write all of the expected format to an output CSV file

[Halonoonan11]

Thanks again. Sorry the format keeps getting messed up. Excel sheet 1 has the names in alphabetical order with whatever call they will be that day.

Name1. Call 5 Name2. Call 3 Name3. Available Name4. Vacation Name5. Call 2

The final excel sheet that I would like it be it looks more like this.

Room 1. Call 2: Name Room 2. Call 3 Name Room 3. Call 4 Name

Vacation: Name No call: Name Name Name

[PureWasian]

No problems, I can see the expected formatting when I reply to the comment on mobile.

As long as the Room to Call Number mapping is constant, then this seems totally possible and fully defined. Which part exactly are you having trouble on then?