title: Split decimal from text as batch
body: <p>Attempting to split decimal numbers in batch using a prevo=ious formula provided on here however the result is an error stating that null or &quot;&quot; or &quot;x&quot; (where is a number) cant be converted to the type list.</p>
  <p>The formula:</p>
  <p><code>=try Text.Remove([Column1],Text.ToList(Text.Remove([Column1],{&quot;0&quot;..&quot;9&quot;,&quot;.&quot;}))) otherwise null</code> works when applied to a single column however when trying to create a create a table from these columns I get the followings errors:</p>
  <p><a href="https://i.stack.imgur.com/XxpBi.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/XxpBi.png" alt="enter image description here" /></a></p>
  <p>Desired Output:</p>
  <p><a href="https://i.stack.imgur.com/bzNtt.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bzNtt.png" alt="enter image description here" /></a></p>
  <p>M Code:</p>
  <pre><code>let
      Source = Excel.CurrentWorkbook(){[Name=&quot;Table19&quot;]}[Content],
      #&quot;Added Custom&quot; = Table.AddColumn(Source, &quot;Custom&quot;, each Table.FromColumns({
          
      (try Text.Remove([Column1],Text.ToList(Text.Remove([Column1],{&quot;0&quot;..&quot;9&quot;,&quot;.&quot;}))) otherwise null), 
      
      (try Text.Remove([Column2],Text.ToList(Text.Remove([Column2],{&quot;0&quot;..&quot;9&quot;,&quot;.&quot;}))) otherwise null)
      
      }))
  in
      #&quot;Added Custom&quot;
  </code></pre>
  <p>I would like to be able to generate a Table.FromColumns, for n columns which I can then expand. This is just an example and in reality, the number of columns can vary quite a lot.</p>
  <p><strong>Update</strong></p>
  <p>To better visualise what I am trying to do in power query I wish to create this scenario:</p>
  <p><a href="https://i.stack.imgur.com/oLL7N.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/oLL7N.png" alt="enter image description here" /></a></p>
  <p>Such that this table can be expanded to:</p>
  <p><a href="https://i.stack.imgur.com/yrYIO.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/yrYIO.png" alt="enter image description here" /></a></p>
  <p>Probably something obvious but any help appreciated.</p>