Hi All,
I am having much difficulty transposing a large data set. The result I am after seems simple but is proving to be somewhat difficult.
I have a list of the following data.
<tbody>
</tbody>
<tbody>
</tbody>
<tbody>
</tbody>
How I would like the data to be,
<tbody>
</tbody>
I know this can be done with a simple transpose formula/paste but my dataset is 47,000 rows long, so copying and pasting individually is not an option. I think VBA might be the way to go, but I havent got a clue where to even start.
Help!
Thank you.
I am having much difficulty transposing a large data set. The result I am after seems simple but is proving to be somewhat difficult.
I have a list of the following data.
Account1 |
a |
b |
c |
<tbody>
</tbody>
Account2 |
d |
e |
f |
<tbody>
</tbody>
Account3 |
g |
h |
i |
<tbody>
</tbody>
How I would like the data to be,
Account1 | a | b | c |
Account2 | d | e | f |
Account3 | g | h | i |
<tbody>
</tbody>
I know this can be done with a simple transpose formula/paste but my dataset is 47,000 rows long, so copying and pasting individually is not an option. I think VBA might be the way to go, but I havent got a clue where to even start.
Help!
Thank you.