This video responds to a question: how can you add a line-feed between every 30th character.
This was a bit intimidating as I wondered WHY would someone’s data be in such a condition? But I thought of an example where area codes might be all smashed together, with no other way to split them apart except for knowledge that they’re always 3 digits long.
In this video, you see Power Query (Get & Transform), split by number of characters, insert line-feed.
My book: Guerrilla Data Analysis 2nd Edition
Thumbnail image taken by Marina Green Photography
My old blog: http://datascopic.net/blog-2-2