C#

+------------+--------------+-----------+--------------+--------+-------------+--------------------+----------+
     | RowNumber  |   Section    | LineItem  | DisplayInCSM | Broker | BrokerName  | ItemValue_NoFormat |  Period  |
     +------------+--------------+-----------+--------------+--------+-------------+--------------------+----------+
     |          1 | Operational  | NG Sales  | NGL          | CR     | Credit Suse |                200 | 2010 FYA |
     |          2 | Operational  | NG Sales  | NGL          | GR     | Max 1       |                300 | 2010 FYA |
     |          3 | Operational  | NG Sales  | NGL          | PX     | Morgan      |                100 | 2010 FYA |
     |          4 | Operational  | NG Sales  | NGL          | WB     | Wells Fargo |                500 | 2010 FYA |
     +------------+--------------+-----------+--------------+--------+-------------+--------------------+----------+

SET @SQL='SELECT *                                      
     FROM                                                                              
     (                      
       SELECT RowNumber,CAST(ISNULL(EarningID,0) AS INT) EarningID,    
       Section,    
       LineItem,    
       DisplayInCSM,     
       Type,     
       Broker,    
       BrokerName,     
       ItemValue_NoFormat,     
       TRIM(ISNULL(Period,'''')) Period,hierarchy,                
       from #tmpData1 WHERE TYPE<>''SHEET''                                                                      
     ) t                                                                              
     PIVOT                                                                              
     (                                                                              
      MAX(ItemValue_NoFormat)                                                                              
      FOR Broker IN ([5W], [8K], [CL], [DA], [EQ], [FA], [GS], [HM], [HQ], [JY], [KW], [ML], [MS], [MV], [SL], [UA],[WB])                                                                              
     ) AS P                                                                              
     order by hierarchy,PeriodOrder

<Grid>
        <Button x:Name="button" Content="Copy" HorizontalAlignment="Left" Height="39" Margin="10,10,0,0" VerticalAlignment="Top" Width="110"/>
        <Grid HorizontalAlignment="Left" Height="287" Margin="138,10,0,0" VerticalAlignment="Top" Width="370">
            <TextBlock x:Name="textBlock" HorizontalAlignment="Left" Height="22" Margin="10,10,0,0" TextWrapping="Wrap" Text="Enter your age:" VerticalAlignment="Top" Width="87"/>
            <TextBox x:Name="textBox" HorizontalAlignment="Left" Height="22" Margin="113,10,0,0" TextWrapping="Wrap" VerticalAlignment="Top" Width="247"/>
        </Grid>

    </Grid>

public partial class MainWindow : Window
   {
       public MainWindow()
       {
           InitializeComponent();
       }

       private void button_Click(object sender, RoutedEventArgs e)
       {
           // I can achieve this with 2 list and a zip then easily building the stringbuilder or string.
           // Trying to see if a more efficient way to bind the textblock text and textbox entered text in xml
       }
   }

List<string> periods = new List<string>();
                 periods.Add("2010 FYA");
                 periods.Add("2011 FYA");
                 periods.Add("2012 FYA");
                 periods.Add("2013 FYA");
                 periods.Add("1Q 2014A");
                 periods.Add("2Q 2014A");
                 periods.Add("3Q 2014A");
                 periods.Add("4Q 2014A");
                 periods.Add("2014 FYA");
        
                 var xx = periods.Where(a => a.ToString() == "2010 FYA" && a.ToString() == "3Q 2014A").ToList();