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 bananaswould 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
Please click on the last line of this post and read the instructions on how to post data in this forum. Once you have done that, use the pre tags as instructed so that your data will maintain its column layout.
DerbyDad03
Office Forum ModeratorClick Here Before Posting Data or VBA Code ---> How To Post Data or Code.