Forum Discussion
RSchwarz84
Apr 07, 2019Copper Contributor
Is using a pivot table for this the right choice?
Dear fellow community members, I have the following problem. For our community yard sale we have given out numbers to people who want to sell things. The list I have has all 90 numbers in column ...
SergeiBaklan
Apr 07, 2019Diamond Contributor
RSchwarz84 , PivotTable works if you add helper column to your data to calculate sequential number of numbers for each name, could be as
=COUNTIF($B$2:$B2,B2)
and drag it down. Pivot all three columns, names in rows, sequence in columns and numbers as values.
Please see the sample attached