how to copy and paste a column of cell to other destianted column

[jeffwongarrow]

Good day everyone

I am encountering an issue of copy a column data to other column, wondering if anyone could help. thank you

original data

ID	Newly Added	Grade (10 Nov 2020)	Grade (3 Nov 2020)	Grade (27 Oct 2020)	Grade (20 Oct 2020)	Grade (13 Oct 2020)	Grade (06 Oct 2020
123	In progress	NA	NA	NA	NA	NA	NA
234	06	NA	NA	NA	NA	NA	NA
345	07	NA	NA	NA	NA	NA	NA
456	In progress	NA	NA	NA	NA	NA	NA
567	03	NA	NA	NA	NA	NA	NA

Expect output

ID	Newly Added	Grade (10 Nov 2020)	Grade (3 Nov 2020)	Grade (27 Oct 2020)	Grade (20 Oct 2020)	Grade (13 Oct 2020)	Grade (06 Oct 2020
123	In progress	In progress	NA	NA	NA	NA	NA
234	06	06	NA	NA	NA	NA	NA
345	07	07	NA	NA	NA	NA	NA
456	In progress	In progress	NA	NA	NA	NA	NA
567	03	03	NA	NA	NA	NA	NA

[atcodedog05 · Accepted solution]

Hi @jeffwongarrow 

You can try something like this.

If you are trying to write in a exiting column you might be facing Datatype issue. Hence you need to exclude the column and create the same column in a formula tool.

There is 2 scenarios you can check them out.

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[RolandSchubert]

Hi @jeffwongarrow ,

I think, column names vary, so I would recommend to move column to rows, use a Multi-Row Formula tool to copy the values and move rows back to columns.

 

I've attached a sample workflow. Let me know if it works for you.

Best,

Roland

[jeffwongarrow]

thank you as always

[atcodedog05]

Happy to help 🙂 @jeffwongarrow 

Cheers and Happy Analyzing 😀