• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Extract Data to a table

jonastiger

Member
Hi
I have a table similar to this:
91071112345,12357,12386
91071212361,12362
94075123145,23156,23188
94080132512
94080236981,45678,445521
94080347188,25896,98765
And I want to transform it in this:
91071112345
91071112357
91071112386
91071212361
91071212362
94075123145
94075123156
94075123188
94080132512
And so on....
Is there a possible way in Excel?
Thanks in advance
 
Here is an alternative Power Query

Code:
let
    Source = Excel.CurrentWorkbook(){[Name="Table3"]}[Content],
    #"Split Column by Delimiter" = Table.ExpandListColumn(Table.TransformColumns(Table.TransformColumnTypes(Source, {{"Column3", type text}}, "en-US"), {{"Column3", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), let itemType = (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), "Column3")
in
    #"Split Column by Delimiter"
 
Back
Top