How can I convert a vertical list of data to a horizontal chart with lists below in Excel?

Is there a way to convert a dataset that looks like thisVertical Dataset

to a horizontal dataset with vertical lists like thisHorizontal Dataset

Note: the first column is turned into the header, and lists are created based on the header.

Thank you!

1 Answer

I added another column to the data, which essentially counts the values in each group. The formula in cell C2, copied to the rest of column C, is =COUNTIF(A$2:A2,A2)

Then I made a pivot table from this data, with Group in the columns area, Counter in the rows area, and Value (or Percent in your table) in the values area.