yogi_Conditionally Format Set(s) Of 6 Rows Of Columns Where First Row Of Column Equals Today's Date And Other 5 Rows Are Non-Blank

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 :(

AlternatingRow

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

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:

https://docs.google.com/spreadsheets/d/12oE4nrLHrI5_I37DU3iFKvNae7xb2FIXg3Bt-Uavqf0/edit?usp=sharing

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 McIlroy	42249	BEST BET
Justin Rose	42217	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

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     2001	red	2	bb	1b
3     3001	black	3	cc	1c
Desired solution A	B
1   1001	blue
2   1001	1
3   1001	aa
4   1001	1a
5   2001	red
6   2001	2
...   2001	bb
2001	1b
3001	black
3001	3
3001	cc
3001	1c

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