Hi, I am hoping someone can help me out transposing some data. Ive got a raw excel file with all the data in column A. Every 21 lines this is suppose to be posted across the same row. I've tried manually selecting every 21 lines and repasting this with the transpose option. Problem is that there are hundreds of sample sizes that i need to do this with on a monthly basis.
Is there a quick way to have every 21 lines automatically in the same row?
Thank you!
Is there a quick way to have every 21 lines automatically in the same row?
Thank you!