Forum Discussion
Solved
power query - data cleaning and analysis
Hi Team, Please the attached excel workbook contains two sheet namely "system data" which was generated from a system and the second sheet "transformed" which was generated using "text to column". i...
i am talking about the fixed width feature as shown belowSergeiBaklan
Actually that is much more powerful Table.SplitColumn() function which could be called from here
i am talking about the fixed width feature as shown belowSergeiBaklan
In your case it's not very needed. As variant, you may select Split from Non-digit to digit and in formula bar change
on
Result will be the same as you split by positions the sample we discussed.
Your method worked perfectly but failed to split the headings. i also applied the same method to a different data with the same problem and the results were not up to expectation but with "text to column" it worked in all the different data it was applied to. SergeiBaklan