Hello Excel Gurus,
I'm trying to write a code that will transform my data from singular columns to multiple rows. My data is currently organized like this;
<tbody>
</tbody>
I need a code that will loop through each row to transform the information into this format. Any help is greatly appreciated. Thanks.
<tbody>
</tbody>
I'm trying to write a code that will transform my data from singular columns to multiple rows. My data is currently organized like this;
Index | Budget View | 1/1/2018 | 2/1/2018 | 3/1/2018 | 4/1/2018 |
123 | Budget | $10.00 | $10.00 | $10.00 | $10.00 |
123 | Forecast | $10.00 | $0.00 | $5.00 | $5.00 |
<tbody>
</tbody>
I need a code that will loop through each row to transform the information into this format. Any help is greatly appreciated. Thanks.
Index | Budget View | Date | Amount |
123 | Budget | 1/1/2018 | $10.00 |
123 | Budget | 2/1/2018 | $10.00 |
123 | Budget | 3/1/2018 | $10.00 |
123 | Budget | 4/1/2018 | $10.00 |
123 | Forecast | 1/1/2018 | $10.00 |
123 | Forecast | 2/1/2018 | $0.00 |
123 | Forecast | 3/1/2018 | $5.00 |
123 | Forecast | 4/1/2018 | $5.00 |
<tbody>
</tbody>