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
You may query the column, slit text by position, change types, return table into sheet and add totals.
Please check in attached.