Excel formula to convert groups of columns to a single row -


i struggling formula. have tried number of different calculations, cannot seem figure out. below data table

source data

what trying achieve below

required result

if source starts a1 (not row number, date value), put formulas in
q1: =int((row()-1)/3)+1
r1: =indirect(address(q1,(mod((row()-1),3))*5+1))
s1: =indirect(address(q1,(mod((row()-1),3))*5+2))
t1: =indirect(address(q1,(mod((row()-1),3))*5+3))
u1: =indirect(address(q1,(mod((row()-1),3))*5+4))

then select 5 cells, , pull them down, results


-

Comments

Post a Comment

Popular posts from this blog

java - SSE Emitter : Manage timeouts and complete() -

i writing web app multiple listeners(evcentsource sse clients js) connected server . want store sse emitter per connected listener : can done in memory or other means assigning id each client able achieve far now question ; how send response/event specific client connected web app ? while doing sseemmiters stored either getting completed or timed out. how prevent ? how keep sseemmiter available open infinite time (till client closes) , send events selectively .
Read more

Voice chat over bluetooth between Android & Python (pybluez) -

i need stream live audio between android , python (pybluez). at first, i've thought sip, i've understood works on android internet , not bluetooth. so - solution i'm thinking on send voice data on sockets, in project: https://github.com/deanthomson/android-udp-audio-chat my big issue solution bluetooth sockets has no "udp mechanism". rfcomm bluetooth sockets connection oriented, tcp sockets, , i'm worrying can lead bad audio transfer speeds.. should use method transfer 2-way live audio on bluetooth?
Read more

Integrate jquery-globalize into an ASP.NET Core MVC App -

in tutorial : building first asp.net core mvc app visual studio purpose build simple movie application. @ step adding model there note below : note you may not able enter decimal points or commas in price field. support jquery validation non-english locales use comma (”,”) decimal point, , non us-english date formats, must take steps globalize app. see additional resources more information. now, enter whole numbers 10. but did not found in mentioned additionnal resources how integrate jquery date / decimal inputs when using non english locale. this explain in tutorial : getting started asp.net mvc 5 @ step 7 examining edit methods , edit view (near end of page). same tutorial targeting asp.net mvc, not asp.net core mvc. i tried follow same steps stuck because _layout view in asp.net core mvc tutorial cannot set same way in asp.net mvc tutorial. do know how integrate jquery globalize js package asp.net core mvc web app ? or better can translate conc...
Read more