Hello,
I have a long string of data that is laid out horizontally and I am trying to find a way (without VBA) to relatively easily convert it to be vertically stacked. Below is a small example of what I need to be able to do on a much larger scale.
If I set up the horizontal spreadsheet to have the 6 rows for each 1 row of data on the horizontal, is there a formula that allows me to look up a combination of styles and types from the vertical table and grab them from both the column and row in the horizontal table?
<tbody>
</tbody>
I have a long string of data that is laid out horizontally and I am trying to find a way (without VBA) to relatively easily convert it to be vertically stacked. Below is a small example of what I need to be able to do on a much larger scale.
If I set up the horizontal spreadsheet to have the 6 rows for each 1 row of data on the horizontal, is there a formula that allows me to look up a combination of styles and types from the vertical table and grab them from both the column and row in the horizontal table?
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody> </tbody> |
<tbody>
</tbody>