L
Lars-Åke Aspelin
Assuming that the first column of your list is named AllData you can
try this formula in cell A4 in "another sheet":
=IF(ROW()-3>COUNTIF(AllData,$A$1),"",OFFSET(INDEX(AllData,SMALL(((AllData)=$A$1)*ROW(AllData),ROW()-3+ROWS(AllData)-COUNTIF(AllData,$A$1))),0,COLUMN()-1))
Copy this formula to the cells B4 and C4.
Then copy the formula down as far as needed.
The cells A3, B3, and C3 you edit manually to get the column headings
Hope this helps. / Lars-Åke
try this formula in cell A4 in "another sheet":
=IF(ROW()-3>COUNTIF(AllData,$A$1),"",OFFSET(INDEX(AllData,SMALL(((AllData)=$A$1)*ROW(AllData),ROW()-3+ROWS(AllData)-COUNTIF(AllData,$A$1))),0,COLUMN()-1))
Copy this formula to the cells B4 and C4.
Then copy the formula down as far as needed.
The cells A3, B3, and C3 you edit manually to get the column headings
Hope this helps. / Lars-Åke