How to generate columns from a list of unknown length?

Question

excel

There is a list of text values, for example, nicknames in the form of one column.
It is necessary that a column be created for each unique nickname in the same sheet, in the first line - the text of the nickname, the second line - the number of its repetitions.
Should I do a pivot table or what?

Answer 1

Yes, summary
Strings - nicknames, values ​​- nicknames