Move columns into one column

VahidDM Ashish_Mathur 

The  example used was a simple table of 3 fields. to do a test run and it worked.

The real data contains the following ..
13 different tasks/fields. The columns formatted as text.
and contain values either the date or N/A.

The 13 different tasks to be in the one column.

and an additional 6 fields needed to align and be displayed next to the tasks eg

Staff name, All Tasks, date due, department, team, cateory 1, category 2, comments

Total fields 8
Total records 116

I select all 13 fields the different tasks, and Unpivot Select columns.
The results

1,433 rows created
however only 2 data records display.

From what I can see the 2 records contain only date values in all 13 tasks.
All other records are blank rows 1 column. The records orginal columns contain a mix of data in tasks types, ie date or N/A 

Is there a way to bring ALL data for the 116 records into the 1 column, which will give a total of 1508 records?

TIA