good morning

A B C D
Equipment serial type model
mudump 123 triplex 1600hp

In another sheet

A B C D
Equipment serial model type
mudump 123 1600hp 1600hp

i need to collect "type" in column C without copy and paste because the data
is too wide more than those items