Split column in two

[webportal]

Hello,

My table has the following structure:

I need to analyse the variance of views by page title from the periods in column B: 2016 vs 2015.

For that, I'm using Power BI desktop. I'm trying to split column B in two: one with the period 1/jan/2015-19/ago/2015 and other with 1/jan/2015-19/ago/2015

Is this possible to do? How?
I tried unpivoting but it didn't work.

Thanks in advance for helping!

[ankitpatira · Accepted solution]

@webportal You actually need to Pivot it. See below image.

[webportal]

Hi,

Pivot is the word indeed (not split).

However, I have other values columns, like time on page, bounce rate, etc.

After pivotting the column, the table becomes a mess...

Perhaps I should go back to Excel, build a pivot table and copy-paste values to another table.

Or is there a way to pivot a column with multiple value columns?

Thanks for helping!