Forum Discussion
power query - data cleaning and analysis
i am talking about the fixed width feature as shown belowSergeiBaklan
forgot csv
SergeiBaklan Appreciated, it is really same what i am looking for
Thanks a lot
could you please elaborate little more or could you please suggest some video related to this topic
Thanks once again ..
First we remove the row with date of extraction
and split the rest on the tables having blocks of 15 rows each
Each table in this list is transformed by function, results are combined.
What function do is first renames columns with needed information in the table
, remove all other columns, replace spaces and empty strings on null. Next transform table to columns, in each column remove nulls and combine table back from such columns.
Appreciated
mind blowing!
I am quite good in macros and data visualization, but I don't have any hesitations to saying, that I need much more class in advance excel. with data model
Thanks
Naushad Ali
- Greetings,
one more thing, if the sequence of the gap is not uniform, which means currently you are splitting the table in 15 rows. what if the data start after 20 rows or after 10 rows then how can i split table.
* can we search for the end line which having dashes ---- and split on that basis
you know better than me, please advice
Thanks
Naushad Ali