Power Query - Unstack data

[Mathexcel]

Hi MrExcel Community,

I am facing a new unstacking data challenge. ?

Context
I have a bunch of Property Names, two Attributes which are stacked together in the following order: (1) a date (in a text format) and (2) a percentage change and their Values.

Target
Here is that table format I am aiming to get:

Property Name	Date	Value	Percentage
Property1	Tue 07 Jan 2020	67​	-0.0944722​
Property1	Wed 08 Jan 2020	67​	-0.0693152​

> I am thinking to add an index column to indicate if it is a Date or a Percentage, but don't have the skills to execute this query (yet).

Table Source
Here is a sample of the data source:

Property Name	Attribute	Value
Property1	Tue 07 Jan 2020	67​
Property1	Column5	-0.09447​
Property1	Wed 08 Jan 2020	67​
Property1	Column7	-0.06932​
Property2	Thu 09 Jan 2020	59​
Property2	Column9	-0.06349​
Property2	Fri 10 Jan 2020	59​

Would anyone know how to transform this piece of data into the desired format?

I appreciate your precious time. ?

Matthieu

 

[Mathexcel]

Legend!! ✌Thanks for the feedback, much appreciated!

I tried to punch into my model your Calendar Table but I'm not sure how this really works. It calls for Table1, which I don't have. I'll be grateful for further pointers as how to implement this.
> Do I need to create a table labelled as Table1 with the below headers and no data so the function fills it?

Headers: Date, Year, Month, Month Name, Quarter, Week of Year, Week of Month, Day, Day of Week, Day of Year, Day Name, Month Year, Week Year

 

[bkjohn2016]

That is a dynamic calendar...it feeds off of your fact table. Whatever the name of your table is...that's what you put into "Table1". And whatever the name of your date field is in that table...that's what you you put into "Attribute". You only have to do this in the start date and end date.

 

[Mathexcel]

Ok thanks. It's great to learn something here but I think I'm doing something wrong.

I'm not sure how to make these two work together. I created a blank query and pasted the 1st code there, but it says it cannot find Table1.
Could you give me some pointers on how to kick this off and to get this running?

Many many thanks.
MattExcel

 

[Mathexcel]

This is the error I am getting.

 

[Mathexcel]

Nope, I got it. Thank you!