SogK
03-29-2021, 04:54 PM
Hello,
I'm very new to using macros and have no clue what's going on, so i need your help!
I'm trying to create a report by transposing my data with a slight twist. The original data looks like this:
https://i.stack.imgur.com/w3nQ3.png
What i want to paste into a new sheet should look like this:
https://i.stack.imgur.com/8DGuD.png (https://i.stack.imgur.com/8DGuD.png)
The number of columns will stay locked but the number of rows will get expanded. I need a macro button to loop through rows until reaches empty. Thank you for the help!!!!!
I'm very new to using macros and have no clue what's going on, so i need your help!
I'm trying to create a report by transposing my data with a slight twist. The original data looks like this:
https://i.stack.imgur.com/w3nQ3.png
What i want to paste into a new sheet should look like this:
https://i.stack.imgur.com/8DGuD.png (https://i.stack.imgur.com/8DGuD.png)
The number of columns will stay locked but the number of rows will get expanded. I need a macro button to loop through rows until reaches empty. Thank you for the help!!!!!