How to Create an array or 2 columns table using select - select from list of values - row/column constructor

----------------Syntax---------------------------

SELECT

FROM
(
Values
( ValueForField1, ValueForField2,..., ValueForFieldN ),
( ValueForField1, ValueForField2,..., ValueForFieldN ),
( ValueForField1, ValueForField2,..., ValueForFieldN ),
( ValueForField1, ValueForField2,..., ValueForFieldN ),
( ValueForField1, ValueForField2,..., ValueForFieldN )
) AS TempTableName ( FieldName1, FieldName2, ..., FieldNameN )
-------------------Example-------------------

select * from (values ('1',2),('2',3) ) as a (datacol,datacol2)

Or same simmilar array could be built using below method

SELECT * FROM (VALUES('Row1'),('Row2'),('Row3')) as tbl1 ([ColumnFieldName1])
,(VALUES('NoOfColumns1'),('NoOfColumns2')) AS z([ColumnName2])