Saturday, October 7, 2017

yogi_Rearrange Into Sheet 2 Data From Each Row Of Multiple Columns of Sheet1 Into Rows Of 5 Columns

Google Spreadsheet   Post  #2261

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Oct-07-2017
Question by Luke Terheyden!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 

I want the sheet to look like this: 

How do I do this? Thanks!