Manual file handling might be a reason for your organization losing money and your employees losing interest in their duties. The best way to accelerate all enterprise procedures and increase your data is to deal with everything with cutting-edge platform like DocHub. Handle your files and Save Customer Feedback in Excel in a matter of mere seconds and save more time for relevant tasks.
With DocHub, you have unlimited use of your files and Templates available for you at any moment. Explore all features right now with the free DocHub profile.
[Music] hello and welcome everyone to this video on analyzing data of 360-degree feedback a junior member of a firm is being evaluated by one or more office seniors right and that too on multiple soft skills dimensions such as client communication leadership pressure handling thought leadership and teamwork now the problem with that is that the data is too unstructured for example Jackson Stella to name same person has been evaluated by two of her seniors right now they have given their comments which is in text form under various dimensions as I mentioned earlier now this needs to be cleaned and restructured so that the output looks like this you have Jackson Stella appearing twice along with the two reviewers and the dimensions are mentioned on the heading and the comments made by the senior underneath so let me tell you this case study will involve power query two features one is called fill down and the other is called pivot with no aggregations if you are using 2010 or thirteen v