Good Morning, I just want to know if there is a short cut for the 'Transpose" function doing rows to column. I have 6000 rows that I need to transpose but I want to transpose 10 rows to 10 columns in row #1, then another 10 rows to 10 columns in row #2 etc.
ex.
rows 1-10 transpose to A1, A2, A3, A4, A5, A6, A7, A8, A9, A10
rows 11-20 transpose to B1, B2, B3, B4, B5, B6, B7, B8, B9, B10
rows 21-30 transpose to C1, C2, C3, C4, C5, C6, C7, C8, C9, C10
I attached a sample file for example.
Thanks in advance!
Bookmarks