Question: I have passed two props in two separate renders of the same component and passed one prop as a function and other as a string.
However on accessing it in the component for rendering, it says:
"props.prop1 is not a function"

This my App.js file:

```js
import React from 'react';
import Test from './components/Test';

function App() {

  return (
    <div className="App">
      <header className="App-header">
        <img src={logo} className="App-logo" alt="logo" />
        <p>
          Edit <code>src/App.js</code> and save to reload.
        </p>
        <Test prop1={() => {return "a"}}/>
        <Test prop2="b"/>

      </header>
    </div>
  );
}

    export default App;
```

This my Test.js file:

```
import React from "react";

function Test(props) {
  return (
    <>
      <div className="test">
        <div>Test data {props.prop1()} </div>
        <div>{props.prop2}</div>
      </div>
    </>
  );
}

export default Test;

```

Answer: 
You can use the `Table.ReplaceRows` method:

```
let
    Source = Excel.CurrentWorkbook(){[Name="Table25"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,
        List.Transform(Table.ColumnNames(Source), each {_, Int64.Type})),

    //create a record of nulls for each column
    replaceList= Record.FromList(
                    List.Repeat({null},Table.ColumnCount(#"Changed Type")), 
                    Table.ColumnNames(#"Changed Type")),

    //Replace the row or rows at Offset with the new list
    nullTheRow = Table.ReplaceRows(#"Changed Type",6,1, {replaceList})

in
    nullTheRow

```

**Source**  

[![enter image description here](https://i.stack.imgur.com/1l2VC.png)](https://i.stack.imgur.com/1l2VC.png)

**replaceList**  

[![enter image description here](https://i.stack.imgur.com/8cEBa.png)](https://i.stack.imgur.com/8cEBa.png)

**Results**  

[![enter image description here](https://i.stack.imgur.com/hIyya.png)](https://i.stack.imgur.com/hIyya.png)
You could transpose the table and add a column containing only null values. Here is an example using the following sample table:

[![table_sample](https://i.stack.imgur.com/2fGoX.png)](https://i.stack.imgur.com/2fGoX.png)

Here is the M code:

```
let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45Wci/KLy0wVNJRMgXikMqCVBDb0EgpVgcqZwTkWyLLmUPkfBQck5PzS/NKioGCQOSTmJSak5qCIgo3xATIM4caAjLQ0FQpNhYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Account Group" = _t, Value1 = _t, #"Account Type" = _t, Value2 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Account Group", type text}, {"Value1", Int64.Type}, {"Account Type", type text}, {"Value2", Int64.Type}}),
    #"Demoted Headers" = Table.DemoteHeaders(#"Changed Type"),
    #"Transposed Table" = Table.Transpose(#"Demoted Headers"),
    #"Added Custom" = Table.AddColumn(#"Transposed Table", "Custom", each null),
    #"Reordered Columns" = Table.ReorderColumns(#"Added Custom",{"Column1", "Column2", "Column3", "Custom", "Column4"}),
    #"Removed Columns" = Table.RemoveColumns(#"Reordered Columns",{"Column4"}),
    #"Transposed Table1" = Table.Transpose(#"Removed Columns"),
    #"Promoted Headers" = Table.PromoteHeaders(#"Transposed Table1", [PromoteAllScalars=true]),
    #"Changed Type1" = Table.TransformColumnTypes(#"Promoted Headers",{{"Account Group", type text}, {"Value1", Int64.Type}, {"Account Type", type text}, {"Value2", Int64.Type}})
in
    #"Changed Type1"

```

And here is the result:

[![null_row](https://i.stack.imgur.com/R1OlI.png)](https://i.stack.imgur.com/R1OlI.png)