Hi everyone.
I have an array of data with a number in each row and one to three columns of data in each row that roughly appears like this:
I need a formula to convert this into two columns.
The first column should contain only the numbers in the first column where data is present in the adjacent columns on each row, repeated for each column on that row. The second columns should contain the data from the next three columns stacked on top of each other.
This formula would make the example set would look like this:
1 Data1
3 Data2
3 Data3
3 Data4
4 Data5
4 Data6
5 Data7
And so on.
How can this be accomplished?
I have an array of data with a number in each row and one to three columns of data in each row that roughly appears like this:
| 1 | Data1 | ||
| 2 | |||
| 3 | Data2 | Data3 | Data4 |
| 4 | Data5 | Data6 | |
| 5 | Data7 |
I need a formula to convert this into two columns.
The first column should contain only the numbers in the first column where data is present in the adjacent columns on each row, repeated for each column on that row. The second columns should contain the data from the next three columns stacked on top of each other.
This formula would make the example set would look like this:
1 Data1
3 Data2
3 Data3
3 Data4
4 Data5
4 Data6
5 Data7
And so on.
How can this be accomplished?
