Timeline for Converting multiple columns to list
Current License: CC BY-SA 4.0
13 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 13, 2019 at 4:20 | history | edited | Rubén - Volunteer Moderator -♦ | CC BY-SA 4.0 |
added 70 characters in body; edited tags
|
| Dec 13, 2019 at 3:54 | answer | added | Felix Pau | timeline score: 1 | |
| Dec 13, 2019 at 3:21 | comment | added | Rubén - Volunteer Moderator -♦ | Good. Please post your solutions as answer. | |
| Dec 13, 2019 at 3:20 | comment | added | Felix Pau | I got it, for the noobies like me who are searching =query({'Order entry'!A1:E; {'Order entry'!A2:C, 'Order entry'!F2:G}},"SELECT * WHERE Col4 is not null AND Col5 is not null order by Col1") apparently i didnt need to convert col1 | |
| Dec 13, 2019 at 2:31 | comment | added | Felix Pau | I got some help and ended up with this, that calls the data in the sorted manner I needed for analysis. The formula I'm using is =query({'Order entry'!A1:E; {'Order entry'!A2:C, 'Order entry'!F2:G}},"SELECT * WHERE Col4 is not null AND Col5 is not null") I tried to append ORDER BY but can't seem to get it right in terms of converting col1 to date. I'm generally guessing its something on the lines of '"&TEXT(DATEVALUE("COL1"),"yyyy-mm-dd")&"'" but I'm unsure if I need to convert the column first with arrayformula, would that be around the current formula? Any help is appreciated | |
| Dec 13, 2019 at 1:49 | history | edited | ale |
edited tags
|
|
| Dec 12, 2019 at 23:13 | comment | added | Felix Pau | Thanks Ruben, apologies for the similar questions. Just didn't know how to approach this question and finding a resolution. I tried going down the path of using Viktor's unpivot, albeit unsuccessful at this time. I'll keep trying. | |
| Dec 12, 2019 at 23:12 | history | edited | Felix Pau |
edited tags
|
|
| Dec 12, 2019 at 21:41 | comment | added | Rubén - Volunteer Moderator -♦ | We have several similar questions : Transpose Ranges repeated by row | |
| Dec 12, 2019 at 21:30 | history | edited | Felix Pau | CC BY-SA 4.0 |
added 98 characters in body
|
| Dec 12, 2019 at 20:55 | history | edited | Felix Pau | CC BY-SA 4.0 |
added 18 characters in body
|
| Dec 12, 2019 at 20:50 | review | First posts | |||
| Dec 13, 2019 at 6:40 | |||||
| Dec 12, 2019 at 20:47 | history | asked | Felix Pau | CC BY-SA 4.0 |