This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hi, I have a quick question on combining 2 columns into 1 row.
I have the following dataset:
As the data is essentially the same in both columns, I want to combine them so that they are all in one column. Also I want the 'Financial Period' column to take priority in the event there is a duplicate in both.
Please not that the values are not unique as there could be multiple months/years.