copy paste

[amitsingh145]

Hi,

I just want to copy the content of first column to next column and so on.

Just like in the excel file.

Please suggest.

Thanks

[Ladarthure]

Hi,

to do so, you cna use the multi-row formula which allows you to make a reference to a previous line (see attached workflow for details)

[GiuseppeC · Accepted solution]

Hi @amitsingh145,

I may have misinterpreted what you want to achieve, but your sample data seems to suggest you want to fill in rows, rather than column.

If that's the case, please find attached a solution using the Multi-Row Formula tool, otherwise, can you please clarify?

Hope this helps!

Giuseppe

[amitsingh145]

Yes, it is column. 🙂

[amitsingh145]

Hi, 

Problem is only in top few rows it is showing null. Other cells are blank.

Please see attached file.

Columns- Test,Day,Opponent,Ground.

Thanks

[Ladarthure]

hi @amitsingh145,

you can use my solution (second post) it solves the problem, the thing is that the isnull formula only check for null values whereas the isempty check for null or empty.

[amitsingh145]

Hi,

It is still working for only those cells with null value.

Thanks

[Ladarthure · Accepted solution]

could you send some sample data please (don't have the file here)

[amitsingh145]

Alteryx file.

[Ladarthure · Accepted solution]

in some cells when you put a browse, you will see a red mark, meaning there are spaces at the start or at the end, you can use a trim formula (trim([field]) to remove those uneeded spaces. and then use your multi row formulas.

Hope it helped!