Transpose data into multiple columns

[Poojitha]

Hi, 

I have same type of columns as below. I need to combine them into single column along with the data

Input:                                                                                               

Month	Month of payment	Year	Year of payment
4		2020
4		2020
4		2020
4		2020
4		2020
4		2020
	April		2020
	April		2020
	April		2020
	April		2020
	April		2020
	April		2020
	April		2020

Output:

Month/Month of payment	Year/Year of payment
4	2020
4	2020
4	2020
4	2020
4	2020
4	2020
April	2020
April	2020
April	2020
April	2020
April	2020
April	2020
April	2020

I tried using transpose, but after transposing i was struck at splitting into columns. Please help

[Jonathan-Sherman · Accepted solution]

Hi @Poojitha,

You could use a formula to create the new column? Unless there's a reason you need to be more dynamic?

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[Poojitha]

thanks alot! worked as required!