if column in excel contains value, then copy

If I have a column in excel, that holds 4 different values, but I want each value to appear in its own column, what would i have to do example Dog apples Cat oranges Fish bananas would be: Dog apples Cat oranges Fish bananas LIke, IF Col 1 = Dog Col 2 = apples IF Col 1 = Cat Col 3 = oranges IF Col 1 = Fish Col 4 = bananas

• › Want to assign values to columns in Excel
• › Compare two columns in Excel
• › compare 2 columns in excel
• › how to use if function in excel sheet
• › Lining up multiple columns in excel
• › [Solved] I am trying to do a if statment in excel that has a date
• › Disable insert rows/columns in Excel