power Querry

Question

Experts&nbsp;I have below table. How do i unpivot this&nbsp;Year201320132013201420142014CountryNameFirst dayLast dayNameFirst dayLast dayINDIA&nbsp;A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 28&nbsp;A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 28INDIA&nbsp;B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 36&nbsp;B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 36FIJI&nbsp;C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 40&nbsp;C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 40FIJI&nbsp;D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20

joe_barry · Accepted Answer

Hi&nbsp;palindrome&nbsp;&nbsp;If this is a one off project and the Excel you are shoing will not change, then you can do this&nbsp;Create a copy of the QueryRename one query to 2013 and the other 2014In 2013 delete the 2014 columns and vice versaIn both tables delete the first rowIn both tables add a coloumn and enter the year in thereThen Append both tables together&nbsp;If this is a live Excel and is updated regulary, tell the owner if they want to visualise the data in Power BI then they need to format their Excel into Tabular format.&nbsp;ThanksJoe&nbsp;If you found my answer helpful and it solved your issue, please accept as solution

Forum Discussion

power Querry

1 Reply

Related content

Cant find ribbon framework on power querry

Date.ToText Power Querry issue

Power querry Join

average without Zero - Power querry

power querry doesnt read all files

Year	2013	2013	2013	2014	2014	2014
Country	Name	First day	Last day	Name	First day	Last day
INDIA	A	1	28	A	1	28
INDIA	B	5	36	B	5	36
FIJI	C	6	40	C	6	40
FIJI	D	7	20	D	7	20