Creating an if statement

%3CLINGO-SUB%20id%3D%22lingo-sub-1495766%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20an%20if%20statement%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1495766%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F712779%22%20target%3D%22_blank%22%3E%40Bear_Medicine1961%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFirst%2C%20let%20me%20say%20that%20you%20probably%20should%20not%20be%20posting%20that%20file%20as%20is%2C%20since%20it%20contains%20what%20appear%20to%20be%20names%20and%20some%20personal%20information%20on%20real%20people.%20I've%20notified%20the%20moderators%20of%20the%20board%20to%20take%20it%20down%2C%20but%20if%20you're%20monitoring%20yourself%2C%20you%20can%20go%20back%20and%20edit%20your%20original%20and%20remove%20it%20yourself.%20Once%20you've%20done%20that%2C%20feel%20free%20to%20post%20a%20representative%20sample%20but%20use%20names%20like%20those%20of%20Disney%20characters%2C%20or%20maybe%20some%20from%20the%20Star%20Wars%20universe.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20your%20question%2C%20which%20isn't%20totally%20clear.%3C%2FP%3E%3CP%3E%3CSTRONG%3EIf%3C%2FSTRONG%3E%20%3CEM%3Eevery%20item%20in%20column%20A%20should%20be%20in%20column%20J%3C%2FEM%3E%20on%20the%20same%20row%2C%20%3CSTRONG%3Ethen%3C%2FSTRONG%3E%20go%20to%20column%20J%2C%20cell%20J2%20(since%20J1%20has%20a%20heading%2C%20J2%20is%20the%20first%20cell%20for%20data)%20and%20enter%20%3CSTRONG%3E%3DA2%3C%2FSTRONG%3E%20and%20then%20copy%20that%20down%20to%20the%20bottom.%20But%20if%20it's%20not%20every%20item%20in%20column%20A%2C%20then%20come%20back%20with%20a%20more%20clear%20definition%20of%20which%20items.%20The%20fact%20that%20you%20title%20your%20question%20%22Creating%20an%20IF%20statement%22%20leads%20to%20the%20inference%20that%20you%20are%20wanting%20to%20set%20a%20condition........so%20why%20don't%20you%20spell%20that%20out%20a%20bit%20more%2C%20after%20first%20rendering%20the%20file%20anonymous.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESame%20kind%20of%20condition%20for%20items%20in%20column%20%3CLI-EMOJI%20id%3D%22lia_anguished-face%22%20title%3D%22%3Aanguished_face%3A%22%3E%3C%2FLI-EMOJI%3E%20are%20you%20talking%20about%20every%20item%20in%20column%20D%3F%20If%20so%2C%20just%20set%20up%20a%20%22helper%20column%22%20(insert%20a%20new%20column%20E%20adjacent%20to%20D)%2C%20and%20in%20cell%20E3%20enter%20the%20formula%20%3CSTRONG%3E%3DD2%3C%2FSTRONG%3E%20and%20copy%20that%20down%20to%20the%20bottom.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20it%20probably%20would%20be%20best%20for%20you%20to%20come%20back%20and%20clarify%2C%20using%20a%20sheet%20with%20anonymous%20data.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1495034%22%20slang%3D%22en-US%22%3ECreating%20an%20if%20statement%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1495034%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20data%20that%20is%20column%20a%20that%20shouldn't%20be%20there%20and%20needs%20to%20move%20to%20column%20J.%20I%20want%20to%20know%20what%20is%20the%20best%20remedy%20for%20doing%20so.%20It%20is%20important%20to%20note%20that%20data%20from%20D%2C%20need%20to%20move%20down%20to%20the%20next%20line.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1495034%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1496651%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20an%20if%20statement%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1496651%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20the%20question!%20We%20removed%20the%20attachment%20as%20we%20don't%20allow%20the%20sharing%20of%20personal%20and%20private%20data%20here%20on%20the%20Tech%20Community%2C%20as%20noted%20in%20our%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fcommunity-guidelines%2Fmicrosoft-tech-community-code-of-conduct%2Fm-p%2F31390%22%20target%3D%22_self%22%3ECode%20of%20Conduct%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20want%20to%20attach%20a%20file%20that%20replaces%20those%20names%20with%20obviously%20fake%20names%20or%20other%20placeholders%2C%20that%20would%20be%20fine.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I have data that is column a that shouldn't be there and needs to move to column J. I want to know what is the best remedy for doing so. It is important to note that data from D, need to move down to the next line.

 

2 Replies
Highlighted

@Bear_Medicine1961 

 

First, let me say that you probably should not be posting that file as is, since it contains what appear to be names and some personal information on real people. I've notified the moderators of the board to take it down, but if you're monitoring yourself, you can go back and edit your original and remove it yourself. Once you've done that, feel free to post a representative sample but use names like those of Disney characters, or maybe some from the Star Wars universe.

 

To your question, which isn't totally clear.

If every item in column A should be in column J on the same row, then go to column J, cell J2 (since J1 has a heading, J2 is the first cell for data) and enter =A2 and then copy that down to the bottom. But if it's not every item in column A, then come back with a more clear definition of which items. The fact that you title your question "Creating an IF statement" leads to the inference that you are wanting to set a condition........so why don't you spell that out a bit more, after first rendering the file anonymous.

 

Same kind of condition for items in column are you talking about every item in column D? If so, just set up a "helper column" (insert a new column E adjacent to D), and in cell E3 enter the formula =D2 and copy that down to the bottom.

 

But it probably would be best for you to come back and clarify, using a sheet with anonymous data.

Highlighted

Thanks for the question! We removed the attachment as we don't allow the sharing of personal and private data here on the Tech Community, as noted in our Code of Conduct.

 

If you want to attach a file that replaces those names with obviously fake names or other placeholders, that would be fine.