Wednesday, November 11, 2015

yogi_Sort Range A4:B10 By Time In Column B In Ascending Order While Adding A Blank Row After Each Entry

Google Spreadsheet   Post  #1985
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov-11-2015
post by  krishna Thunisinigam:
https://productforums.google.com/forum/#!topic/docs/UMDIPES1NuI;context-place=forum/docs
How to SORT data in alternating rows?
Hi awesome people

I'm trying to use google sheets to sort a set of data but the tricky bit is I need it to skip a row everytime it returns a result, I've included a link to an example. I would greatly appreciate any assistance on this. Thank you so much all. 

P.S I've used SORT() so far but don't know how I would get it to skip a row though :(


----------------------------------------------------------------------------------------------------------------------------------------


Sunday, November 1, 2015

yogi_Split Concacted Rows Of Data Into Columns By Name Date And Bet

Google Spreadsheet   Post  #1984
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov-01-2015
post by  meph2u:
https://productforums.google.com/forum/#!topic/docs/egukDdSOXuM;context-place=forum/docs
Keeping original format in a split function (and a related arrayformula question)
In this spreadsheet:


I split data like this:


Player
Rory McIlroy — 9/2 — BEST BET
Justin Rose — 8/1 — BEST BET
Brooks Koepka — 15/1 — BEST BET
Hideki Matsuyama — 15/1 — BEST BET
Justin Thomas — 30/1 — BEST BET
Tony Finau — 30/1 — BEST BET
Robert Streb — 30/1
Daniel Berger — 40/1 — BEST BET
Emiliano Grillo — 40/1 — BEST BET
Kevin Na — 40/1 — BEST BET


to get data like this:

Rory McIlroy42249BEST BET
Justin Rose42217BEST BET
Brooks Koepka15/1BEST BET
Hideki Matsuyama15/1BEST BET
Justin Thomas30/1BEST BET
Tony Finau30/1BEST BET
Robert Streb30/1
Daniel Berger40/1BEST BET
Emiliano Grillo40/1BEST BET
Kevin Na40/1BEST BET

Unfortunately, having the 9/2 and 8/1 display as numbers or dates doesn't work for me.   Is there a way to get the cells in red to display 9/2 and 8/1?

Why does this formula in cell b2:  =iferror(split(A2,"—"))

Produce the same results as this formula in cell H2: =iferror(arrayformula(split(A2:A,"—")))

In other words, why doesn't the arrayformula work for all cells H2:H and what can I do to make it work?

Thanks!
------------------------------------------------------------------

yogi_Rearrange Data From A MultiColumn Table Into Two-Column Table With The First Column Value Repeated For Each Row

Google Spreadsheet   Post  #1983
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov-01-2015
post by  Aldo Huizinga:
https://productforums.google.com/forum/#!topic/docs/9d0pU_qFd5s;context-place=forum/docs
How can I transpose multiple columns into 2 columns?
I have multiple columns (57) and would like to transpose them like in this example.

I assume to use "ArrayFormula" but can not find the desired solution.

Hope any of you could help me.

Example




 A
1     1001
B
blue
C
1
D
aa
E
1a
2     2001red2bb1b
 3     3001black3cc1c


Desired solution
A   
    B
 1   1001blue
2   10011
3   1001aa
4   10011a
5   2001red
6   20012
...   2001bb
20011b
3001black
30013
3001cc
30011c

----------------------------------------------------------------------------------------------------------------------------------