0
Is there a way to convert a dataset that looks like this Vertical Dataset
to a horizontal dataset with vertical lists like this Horizontal Dataset
Note: the first column is turned into the header, and lists are created based on the header.
Thank you!
Kyle S
Posted 2019-10-14T22:22:45.290
Reputation: 1
0
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.
Jon Peltier
Posted 2019-10-14T22:22:45.290
Reputation: 3 470
1Yes. What have you tried so far, and where did you get hung up with those approaches? – Alex M – 2019-10-15T00:11:51.430
I have tried to transpose the chart, but this turns every cell in "Group" into it's own column header, rather than having one column for each Group and listing the Percent entries that correspond to it. I have found no other solution. – Kyle S – 2019-10-15T15:40:31.560
I wrote an answer to a similar question not long ago.
– Alex M – 2019-10-15T17:05:03.917OFFSETis just one approach, but it'll definitely work for you here. See if this gets you started: https://superuser.com/questions/1424891/stack-every-nth-column-under-neath-each-other there are also lots of other answers to extremely similar questions in the 'Related' list on that question. It's generally best to do some research before posting a Q.