'Query Data between to strings
So I am importing data from an external program, the problem is it imports the data not separated, so when I import and trans pose it, it ends up like this:
| Column A |
|---|
| String#1 |
| Data 1 |
| Data 2 |
| Data 3 |
| String#2 |
| Data 4 |
| Data 5 |
| Data 6 |
I want to query the Data above so it grabs "string 1" and goes down until it gets to "String2", so I an rearrange the data to look like this:
| String 1 | String 2 |
|---|---|
| Data 1 | Data 5 |
| Data 2 | Data 6 |
| Data 3 | Data 7 |
| Data 4 | Data 8 |
I have absolutely no idea how todo this, my assumption is that the formula would look like this:
=QUERY(A:A, "Select A where A is between 'String 1' and 'String 2')
And no, I cannot change the way the data is imported from the external tool. Any ideas and solutions would be very apricated
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
