With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Saturday, October 7, 2017
yogi_Rearrange Into Sheet 2 Data From Each Row Of Multiple Columns of Sheet1 Into Rows Of 5 Columns
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/Qk2WZVpDLxk;context-place=forum/docs How to transform one row of a 1000 columns into many rows of 5 columns? Hi all,
I am trying to turn a strangely formatted table (see below).
At the moment there are more than 1,000 columns with a repeating structure of columns: tool, session, users, length.
but I want to condense this to just 5 columns titled 1.hotel 2. tool 3. sessions 4. users 5. length