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
Solved! Go to 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
thanks alot! worked as required!