I have a problem with excel spreadsheet, I cant open some of them on my computer, it´s like it opening but then just hangs and finally I get "not responding". I have tried to remove office completely and reinstall it, but that dose not help, I can take same file and open it in any other computers "tried four already" anyone have a clue what I can do ?
Viewers will learn a basic data manipulation technique of unpivoting data in Power Query for Excel 2013 and the importance of using good data.
Start with data in a poor structure:
Create a table on your data: