Hi,
I was wondering can someone help me, i have a sheet with over 100K rows and what i need is to transfer the data from rows to columns, Tried already with index & match but when i drag and drop my excel is not working anymore. Can someone help me to create a macro code for this? On the left side is original version and on right is what i need
<colgroup><col span="2"><col><col span="3"><col><col span="2"></colgroup><tbody>
</tbody>
Pleaseee heeeelp
I was wondering can someone help me, i have a sheet with over 100K rows and what i need is to transfer the data from rows to columns, Tried already with index & match but when i drag and drop my excel is not working anymore. Can someone help me to create a macro code for this? On the left side is original version and on right is what i need
Name | Question | Answer | Country | Phone | ||||
Andrea | test@test.com | Andrea | test@test.com | US | / | |||
Andrea | Country | US | Sara | test@test.com | US | / | ||
Andrea | Phone | / | Maria | test@test.com | US | / | ||
Andrea | Skype | / | ||||||
Sara | test@test.com | |||||||
Sara | Country | US | ||||||
Sara | Phone | / | ||||||
Sara | Skype | / | ||||||
Maria | test@test.com | |||||||
Maria | Country | US | ||||||
Maria | Phone | / | ||||||
Maria | Skype | / |
<colgroup><col span="2"><col><col span="3"><col><col span="2"></colgroup><tbody>
</tbody>
Pleaseee heeeelp