I found a wonderful tool to automatically update dropdown based on the another column. This tool allows you to select source column and destination dropdown column to update data automatically.
You can try this tool.
https://dynamicdropdown.com/