126.1 - Dealing with a pivot-like table structure

In this video I'll handle a pivot-table like data format, which is super nice for filling in data but a mild nightmare for data analysis. Instead of having one column with the task and another for the skill level, we have three columns per skill. These three columns must be combined into one. This first video contains the two easy solutions, centered around transposing and unpivoting. In the next video, we solve the problem with a far more fun method. Easy is boring. 00:00 Intro 00:35 Solution 1, Transpose 01:06 Dealing with the header suffix 03:52 Delete first row 04:00 Unpivot 04:22 Replaced based on the Task column 06:08 Own replacer function 06:42 Remove suffixes 08:15 Optional, One column per task 08:46 Solution 2, New column 09:37 Add correct headers 11:22 Insert header-column as a row 11:38 Fix Danish headers 12:19 Remove first 2 rows