Hi everyone,
I'm currently trying to format a dataset from one worksheet to another worksheet in a specific format. I've been stuck on this problem for a few days and I was hoping to get some input or solutions for this. I have a table that looks like :
Table 1
<tbody>
</tbody>
I'm trying to find a solution to pull the information from the table above into a format like this:
Table 2
<tbody>
</tbody>
Basically Table 2 will have all the defined 4 digit distribution numbers displayed horizontally in row A. And based on the ID, I want to capture all the numbers to the right of the equals sign from table 1 and place them in the appropriate column.
I've tried using index match formulas combined with the right formula but it won't work if an ID has multiple distribution numbers across the row… Any advice would be much appreciated!
I'm currently trying to format a dataset from one worksheet to another worksheet in a specific format. I've been stuck on this problem for a few days and I was hoping to get some input or solutions for this. I have a table that looks like :
Table 1
| ID | Distribution | |||
| 00001111 | 8741=100 | |||
| 00001234 | 2345=20 | 3321=10 | 1298=70 | |
| 00001453 | 1098=50 | 7832=20 | 1123=10 | 5431=20 |
<tbody>
</tbody>
I'm trying to find a solution to pull the information from the table above into a format like this:
Table 2
| 1234 | 8741 | 2345 | 1123 | 2345 | |
| ID | Distribution Name W | Distribution Name X | Distribution Name Y | Distribution Name Z | |
| 00001111 | 100 | ||||
| 00001234 | 20 | ||||
| 00001453 | 10 |
<tbody>
</tbody>
Basically Table 2 will have all the defined 4 digit distribution numbers displayed horizontally in row A. And based on the ID, I want to capture all the numbers to the right of the equals sign from table 1 and place them in the appropriate column.
I've tried using index match formulas combined with the right formula but it won't work if an ID has multiple distribution numbers across the row… Any advice would be much appreciated!
