if column in excel contains value, then copy

May 23, 2011 at 14:30:26
Specs: Windows 7
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


See More: if column in excel contains value, then copy

Report •


#1
May 23, 2011 at 18:27:18
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 Moderator

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question