Railsware<\/a>, I have to consume and produce immense amounts of information. Because of this, it becomes very handy to be able to keep up with it via some engineering magic.<\/p>\n\n\n\nA regexp here, a JavaScript bookmarklet there. A firebug inspection for this, a line of Ruby code for that, and, finally, a bash trick over there.<\/p>\n\n\n\n
Today, I wanted to share a simple issue resolution. I’m to mirror my Excel spreadsheet (rotating data by turning rows into columns and vice versa).<\/p>\n\n\n\n
A quick search for Microsoft Excel revealed a transpose feature in special paste. However, being an Apple aficionado, I use Numbers – so no transpose.<\/p>\n\n\n\n
What should I do? Copy\/paste by hand? No way! Instead, I turn to Ruby, always a piece of cake. And so it was. Two minutes of Numbers menu\/search browsing plus seven minutes of Googling vs. 2 minutes 23 seconds of coding (code snippet below).<\/p>\n\n\n\n
data=\"\";data_reverse=[]\nputs \"past your tab separated data and finish with \"\nbegin data << gets end while data[-2..-1]!=\"n data.split(\"n\").each{|l| l.split(\"t\").each_with_index{|v,x| (data_reverse[x]||=[]) << v} }\n\nputs data_reverse.collect{|line| line.join(\"t\")}.join(\"n\")<\/pre>\n\n\n\nSo, my dear fellow CEOs, CFOs, and C*Os from all around the world, learn to code \u2013 it will save you a lifetime!<\/p>\n","protected":false},"excerpt":{"rendered":"
While my engineering background (9 extensive years of daily coding and 4 years of software producing\/tech leading\/management\/sales) is essential to my job as a CEO of an engineering company, that isn’t what I want to focus on today. Through the course of my day as the CEO of Railsware, I have to consume and produce…<\/p>\n","protected":false},"author":39,"featured_media":16937,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[5],"tags":[],"coauthors":["Yaroslav Lazor"],"class_list":["post-534","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-management"],"acf":[],"aioseo_notices":[],"categories_data":[{"name":"Product Management","link":"https:\/\/railsware.com\/blog?category=management"}],"post_thumbnails":"https:\/\/railsware.com\/blog\/wp-content\/themes\/railsware\/vendors\/images\/article-thumbnail-default.jpg","amp_enabled":true,"_links":{"self":[{"href":"https:\/\/railsware.com\/blog\/wp-json\/wp\/v2\/posts\/534","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/railsware.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/railsware.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/railsware.com\/blog\/wp-json\/wp\/v2\/users\/39"}],"replies":[{"embeddable":true,"href":"https:\/\/railsware.com\/blog\/wp-json\/wp\/v2\/comments?post=534"}],"version-history":[{"count":23,"href":"https:\/\/railsware.com\/blog\/wp-json\/wp\/v2\/posts\/534\/revisions"}],"predecessor-version":[{"id":14154,"href":"https:\/\/railsware.com\/blog\/wp-json\/wp\/v2\/posts\/534\/revisions\/14154"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/railsware.com\/blog\/wp-json\/wp\/v2\/media\/16937"}],"wp:attachment":[{"href":"https:\/\/railsware.com\/blog\/wp-json\/wp\/v2\/media?parent=534"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/railsware.com\/blog\/wp-json\/wp\/v2\/categories?post=534"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/railsware.com\/blog\/wp-json\/wp\/v2\/tags?post=534"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/railsware.com\/blog\/wp-json\/wp\/v2\/coauthors?post=534"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}