Excel condense data

excel

Solution 1:

Use PowerQuery ...! Go to Data -> Get Data -> From File -> From Workbook and then follow these steps.

Rename first column to Name ...

Step 1

Select Column2 and Pivot the data ...

Step 2

Use these options in the pivot ...

Step 3

Voila!

Result

Select Close and Load to populate a new sheet ...

Close and Load

Result ...

Result

Related

Read parquet with binary (proto-buffer) column
How to parse and distinguish different and varying arguments of a user command with a regular expression?
Nestjs overrideProvider vs provider in unit testing
How do you get a struct device for a Linux character device
MySQL update specific JSON objects in an array
Initially I want ON button to be display block and off to display none, if I click ON button, OFF appears & On disappears, and vice versa
How to submit PlayStore app access credentials for google sign in authentication?
Blazor Server available as localhost, but not within local area network. What am i missing?
Can MongoDB Update Aggregation Pipeline conditionally replace the document?
Do not redirect if guest?
Is it possible to create a model from mysql database table in laravel
ansible answers to mysql_secure_installation