<div>
For pivot result you need to translate query to a SelectMany() statement: 
 
&lt;&lt;&nbsp;Non-compliant content removed; kaufmed, Topic Advisor &gt;&gt;
</div>

<div>
Are Start, Middle and end the same type of data? 
 
If the data is coming from a database, you can use the UNION key word with three queries. 
 
You can also use the Linq key word Union. Here is Microsoft's example: <a href="https://msdn.microsoft.com/en-us/library/bb386993(v=vs.110).aspx" rel="ugc">https://msdn.microsoft.com/en-us/library/bb386993(v=vs.110).aspx</a>
</div>

<div>
Hi Waterside; 
 
The following code snippet will do what you want assuming you are starting Withw a DataTable object.
<pre><code class="code-10 nolinks" id="code-20-41306607-1">'' Sample data In a DataTable object.
'' Start of sample data
Dim dt As New DataTable
Dim dc As New DataColumn(&quot;id&quot;, GetType(System.Int32))
dt.Columns.Add(dc)
dc = New DataColumn(&quot;start&quot;, GetType(System.String))
dt.Columns.Add(dc)
dc = New DataColumn(&quot;middle&quot;, GetType(System.String))
dt.Columns.Add(dc)
dc = New DataColumn(&quot;end&quot;, GetType(System.String))
dt.Columns.Add(dc)

Dim dr As DataRow = dt.NewRow
dr(&quot;id&quot;) = 1
dr(&quot;start&quot;) = &quot;A&quot;
dr(&quot;middle&quot;) = &quot;B&quot;
dr(&quot;end&quot;) = &quot;C&quot;
dt.Rows.Add(dr)

dr = dt.NewRow
dr(&quot;id&quot;) = 2
dr(&quot;start&quot;) = &quot;D&quot;
dr(&quot;middle&quot;) = &quot;E&quot;
dr(&quot;end&quot;) = &quot;F&quot;
dt.Rows.Add(dr)

dr = dt.NewRow
dr(&quot;id&quot;) = 3
dr(&quot;start&quot;) = &quot;G&quot;
dr(&quot;middle&quot;) = &quot;H&quot;
dr(&quot;end&quot;) = &quot;I&quot;
dt.Rows.Add(dr)
'' End of sample data

'' Linq query to parse the data
'' Returns a List(Of String)()
Dim results = (From row In dt.AsEnumerable()
 From cell In row.ItemArray
 Select row.Field(Of Integer)(&quot;id&quot;).ToString() &amp; &quot; &quot; &amp; cell.ToString()).ToList()
</code></pre>
 
In the following Image the first is the starting DataTable object and the second is the resulting after the Linq query.<a href="https://filedb.experts-exchange.com/incoming/2015/11_w48/1035361/Voila_Capture-2015-11-24_11-14-42_AM.png" target="_blank" title="Data (13 KB)"><img alt="Data" class="file-block lazyload" style="max-width: 201px;" data-src="https://filedb.experts-exchange.com/incoming/2015/11_w48/1035361/Voila_Capture-2015-11-24_11-14-42_AM.png" /></a>
</div>

Voila_Capture-2015-11-24_11-14-42_AM.png

<div>
@Shaun. &nbsp;I considered using Union, but not certain that the order will be preserved ? 
 
@Fernando. &nbsp;I seem to be missing some methods to make your example work. &nbsp;I'm using LinqtoSQL
</div>

<div>
Can you post the actual Linq to SQL query you used.
</div>

<div>
<pre><code class="code-10 nolinks" id="code-20-41308324-1">Dim data = From s In dc.RoundStreets
 Join p In dc.Streets
 On s.USRN Equals p.USRN
 Where s.RoundId = 1131
 Order By s.RoundOrder
 Select p

 Dim streets As List(Of Street) = data.ToList

 Dim pins = (From f In streets Select coord = New GeoCoordinate(f.StartLat, f.StartLon)).Union _
 (From c In streets Select coord = New GeoCoordinate(c.CenterLat, c.CenterLon)).Union _
 (From l In streets Select coord = New GeoCoordinate(l.EndLat, l.EndLon))
</code></pre>
</div>

<div>
Seeming this is not the same layout of the original question can you post the class of dc.Streets and what properties from that class you want to output as shown in the original question.
</div>

<div>
Sure. &nbsp;I wanted to present something a little more generic to illustrate what I needed.
</div>

<div>
&lt;Table&gt; _ 
Public Class Street 
 
&nbsp; &nbsp; &lt;Column(IsDbGenerated:=True, IsPrimaryKey:=True)&gt; _ 
&nbsp; &nbsp; Public Property Id() As Integer 
&nbsp; &nbsp; &nbsp; &nbsp; Get 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Return m_Id 
&nbsp; &nbsp; &nbsp; &nbsp; End Get 
&nbsp; &nbsp; &nbsp; &nbsp; Set(value As Integer) 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; m_Id = value 
&nbsp; &nbsp; &nbsp; &nbsp; End Set 
&nbsp; &nbsp; End Property 
&nbsp; &nbsp; Private m_Id As Integer 
 
&nbsp; &nbsp; &lt;Column&gt; _ 
&nbsp; &nbsp; Public Property USRN() As Integer 
&nbsp; &nbsp; &nbsp; &nbsp; Get 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Return m_USRN 
&nbsp; &nbsp; &nbsp; &nbsp; End Get 
&nbsp; &nbsp; &nbsp; &nbsp; Set(value As Integer) 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; m_USRN = value 
&nbsp; &nbsp; &nbsp; &nbsp; End Set 
&nbsp; &nbsp; End Property 
&nbsp; &nbsp; Private m_USRN As Integer 
 
&nbsp; &nbsp; &lt;Column(DbType:=&quot;Float&quot;)&gt; _ 
&nbsp; &nbsp; Public Property StartLat() As Nullable(Of Double) 
&nbsp; &nbsp; &nbsp; &nbsp; Get 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Return m_StartLat 
&nbsp; &nbsp; &nbsp; &nbsp; End Get 
&nbsp; &nbsp; &nbsp; &nbsp; Set(value As Nullable(Of Double)) 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; m_StartLat = value 
&nbsp; &nbsp; &nbsp; &nbsp; End Set 
&nbsp; &nbsp; End Property 
&nbsp; &nbsp; Private m_StartLat As Nullable(Of Double) 
 
&nbsp; &nbsp; &lt;Column(DbType:=&quot;Float&quot;)&gt; _ 
&nbsp; &nbsp; Public Property StartLon() As Nullable(Of Double) 
&nbsp; &nbsp; &nbsp; &nbsp; Get 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Return m_StartLon 
&nbsp; &nbsp; &nbsp; &nbsp; End Get 
&nbsp; &nbsp; &nbsp; &nbsp; Set(value As Nullable(Of Double)) 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; m_StartLon = value 
&nbsp; &nbsp; &nbsp; &nbsp; End Set 
&nbsp; &nbsp; End Property 
&nbsp; &nbsp; Private m_StartLon As Nullable(Of Double) 
 
&nbsp; &nbsp; &lt;Column(DbType:=&quot;Float&quot;)&gt; _ 
&nbsp; &nbsp; Public Property CenterLat() As Nullable(Of Double) 
&nbsp; &nbsp; &nbsp; &nbsp; Get 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Return m_CenterLat 
&nbsp; &nbsp; &nbsp; &nbsp; End Get 
&nbsp; &nbsp; &nbsp; &nbsp; Set(value As Nullable(Of Double)) 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; m_CenterLat = value 
&nbsp; &nbsp; &nbsp; &nbsp; End Set 
&nbsp; &nbsp; End Property 
&nbsp; &nbsp; Private m_CenterLat As Nullable(Of Double) 
 
&nbsp; &nbsp; &lt;Column(DbType:=&quot;Float&quot;)&gt; _ 
&nbsp; &nbsp; Public Property CenterLon() As Nullable(Of Double) 
&nbsp; &nbsp; &nbsp; &nbsp; Get 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Return m_CenterLon 
&nbsp; &nbsp; &nbsp; &nbsp; End Get 
&nbsp; &nbsp; &nbsp; &nbsp; Set(value As Nullable(Of Double)) 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; m_CenterLon = value 
&nbsp; &nbsp; &nbsp; &nbsp; End Set 
&nbsp; &nbsp; End Property 
&nbsp; &nbsp; Private m_CenterLon As Nullable(Of Double) 
 
&nbsp; &nbsp; &lt;Column(DbType:=&quot;Float&quot;)&gt; _ 
&nbsp; &nbsp; Public Property EndLat() As Nullable(Of Double) 
&nbsp; &nbsp; &nbsp; &nbsp; Get 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Return m_EndLat 
&nbsp; &nbsp; &nbsp; &nbsp; End Get 
&nbsp; &nbsp; &nbsp; &nbsp; Set(value As Nullable(Of Double)) 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; m_EndLat = value 
&nbsp; &nbsp; &nbsp; &nbsp; End Set 
&nbsp; &nbsp; End Property 
&nbsp; &nbsp; Private m_EndLat As Nullable(Of Double) 
 
&nbsp; &nbsp; &lt;Column(DbType:=&quot;Float&quot;)&gt; _ 
&nbsp; &nbsp; Public Property EndLon() As Nullable(Of Double) 
&nbsp; &nbsp; &nbsp; &nbsp; Get 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Return m_EndLon 
&nbsp; &nbsp; &nbsp; &nbsp; End Get 
&nbsp; &nbsp; &nbsp; &nbsp; Set(value As Nullable(Of Double)) 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; m_EndLon = value 
&nbsp; &nbsp; &nbsp; &nbsp; End Set 
&nbsp; &nbsp; End Property 
&nbsp; &nbsp; Private m_EndLon As Nullable(Of Double) 
 
End Class
</div>

<div>
1 New Geocoordinate(StartLat, StartLon) 
1 New Geocoordinate(CenterLat, CenterLon) 
1 New Geocoordinate(EndLat, EndLon) 
2 New Geocoordinate(StartLat, StartLon) 
2 New Geocoordinate(CenterLat, CenterLon) 
2 New Geocoordinate(EndLat, EndLon)
</div>

<div>
<div class="content wysiwyg-content">
I have a table with columns: id, start, middle, end 
 
id &nbsp;start &nbsp;middle &nbsp;end 
1 &nbsp; &nbsp; &nbsp;A &nbsp; &nbsp; &nbsp; &nbsp; B &nbsp; &nbsp; &nbsp; &nbsp; C 
2 &nbsp; &nbsp; &nbsp;D &nbsp; &nbsp; &nbsp; &nbsp; E &nbsp; &nbsp; &nbsp; &nbsp; F 
3 &nbsp; &nbsp; &nbsp;G &nbsp; &nbsp; &nbsp; &nbsp; H &nbsp; &nbsp; &nbsp; &nbsp; I 
 
I'd like to output.... 
 
1 &nbsp;A 
1 &nbsp;B 
1 &nbsp;C 
2 &nbsp;D 
2 &nbsp;E 
2 &nbsp;F 
3 &nbsp;G 
3 &nbsp;H 
3 &nbsp;I 
 
Any thoughts ?
</div>
</div>

I have a table with columns: id, start, middle, end

id  start  middle  end
1      A         B         C
2      D         E         F
3      G         H         I

I'd like to output....

1  A
1  B
1  C
2  D
2  E
2  F
3  G
3  H
3  I

Any thoughts ?

Linq Columns to Rows

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.