Syntax
SELECT(<any>;<any>;<any><any>;<any>)
Description
Create columns with selected values using a key constant from a specified column in the workbook.
...
This is an excellent tool to create columns for use in a pivot table.
Example
Original data:
| Department | Year | Dollar |
|---|---|---|
| Department 1 | 2010 | 10 |
| Department 1 | 2010 | 20 |
| Department 1 | 2011 | 10 |
Department 2 | 2011 | 10 |
| Department 2 | 2012 | 10 |
...