Is there a way in powerquery to split to columns every 12 commas? I have a text document, where everything is separated by a comma, when really there should be a new row every 12 commas, so I would like to split commas and then transpose the column to rows and then split the columns again by commas, so that I can get a proper table.
Split Columns by Every 12 Commas
June 21st, 2015 1:19am
Can you share a sample of the data? How would you like to handle new lines in the input dataset? Do you have multi line data that should be represented in a single cell?
Free Windows Admin Tool Kit Click here and download it now
June 21st, 2015 2:45am