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
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
could you send some sample data please (don't have the file here)
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!
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)
Yes, it is column. 🙂
