Q:

I have two columns and I want to combine both not by concat just combining one row below the other

I got two columns Named 'Next Schedule Date' and 'Expected Scheduled Date' in Sql table. What I want exactly is to combine two columns not as a concatenation just combining them one row below the other row.
I have tried unPivot but its not working. Any suggestions pls
select [Asset / Location],[Department Name],  Future_Scheduled_Date
from merge2_ernie
Unpivot
(
Future_Scheduled_Date
for [Department Name] in (select Distinct [Department Name] from merge2_ernie)
) as example
My data is now looking something like this 
**Department_Name**    **Next_Schedule_Date**   **Expected_Scheduled_Date**

Dept1                    Aug 2019             Sep 2019
Dept1                    Oct 2019             Nov 2019
Dept2                    Jan 2019             Mar 2019
Dept3                    Nov 2019             Jan 2020
Dept4                    Apr 2019             Sep 2019
Dept5                    Jun 2019             Jul 2019

I want the data to be like this below
Department_Name    Future_Schedule_Date   

Dept1               Aug 2019            
Dept1               Sep 2019           
Dept1               Oct 2019          
Dept1               Nov 2019           
Dept2               Jan 2019
Dept2               Mar 2019
Dept3               Nov 2019
Dept3               Jan 2020
Dept4               Apr 2019             
Dept4               Sep 2019
Dept5               Jun 2019
Dept5               Jul 2019

A:

You can use apply :
select Department_Name, Future_Schedule_Date
from table t cross apply
     ( values (Next_Schedule_Date), (Expected_Scheduled_Date) 
     ) tt(Future_Schedule_Date)
order by Department_Name, Future_Schedule_Date;

