Hello,
I have the results of a survey in an Excel spreadsheet, like this:
<tbody>
</tbody>
and i need to rearrange like this:
<tbody>
</tbody>
I need to automate this process with macros, i was thinking using pivot table but i can't figure out how to bring Comments Column after every question.Any suggestion?
Thanks!
I have the results of a survey in an Excel spreadsheet, like this:
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody>
</tbody>
and i need to rearrange like this:
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | Excellent |
<tbody>
</tbody>
I need to automate this process with macros, i was thinking using pivot table but i can't figure out how to bring Comments Column after every question.Any suggestion?
Thanks!