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

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

20200909 - NewColumns.yxmd