Is Google Spreadsheet conversion possible?

Question

Google Sheets

Is it possible to convert a table

into a table of the form

and so that when rows are added to the first table, columns are added to the second?

Answer 1

In principle, the view you need is formed by pivot tables.