MS Office Exel. The necessary assistance.

Purpose: one column with the names of the positions of the "cut" part numbers in an adjacent column.
Task: need help in solving this problem. There must be some formula or macro to solve this problem.

PS: Manually about every position