Hello All!
I have a table with date in two columns (D&E) that have linked delimited data. If column D has 2 values separated by a "|" delimiter, then column E will have the same number of delimited values.
<tbody>
</tbody>
I'd like the table to look like:
<tbody>
</tbody>
I'd like a macro to help out, as this process will be occurring weekly with a few thousand rows...
I've seen a few examples on here- but nothing with the two linked columns.
Thank you all in advance for your brain power!
Eric
I have a table with date in two columns (D&E) that have linked delimited data. If column D has 2 values separated by a "|" delimiter, then column E will have the same number of delimited values.
A | B | C | D | E |
51 | Bob | PPV | 15 | 9 |
61 | James | CHH | 30|16|5 | 17|5|8 |
22 | Steve | PPV | 55|2 | -14|125 |
5 | Ivan | DCh | 6 | -7 |
<tbody>
</tbody>
I'd like the table to look like:
A | B | C | D | E |
51 | Bob | ppv | 15 | 9 |
61 | James | CHH | 30 | 17 |
61 | James | CHH | 16 | 5 |
61 | James | CHH | 5 | 8 |
22 | Steve | PPV | 55 | -14 |
22 | Steve | PPV | 2 | 125 |
5 | Ivan | DCh | 6 | -7 |
<tbody>
</tbody>
I'd like a macro to help out, as this process will be occurring weekly with a few thousand rows...
I've seen a few examples on here- but nothing with the two linked columns.
Thank you all in advance for your brain power!
Eric