Hot answers tagged

2

Also two steps, assuming 256 is in B2: in C2: =COUNTIF(A$1:A2,A2) copied down to suit in D1: =query(A1:C8,"select A, SUM(B) group by A pivot C")


2

You can accomplish this in two steps: Create a new sheet Sheet2 and use the following formula for A1 (or wherever you want the column to begin): =unique(Sheet1!A:A). This will give you a vertical column of simply A, B, C, and D as the unique values in Sheet1's A column. Combine transpose and filter in the cell adjacent to each cell in Sheet2 as follows: =...


Only top voted, non community-wiki answers of a minimum length are eligible