How can you make a macro to take a column, and split it into multiple columns with a prompt asking how many rows you want it to split at? Basically I have data that takes up 22,000 rows in 1 column, and I need it to only have 500 rows and 44 columns.
does that make sense? I think I saw a macro for this before...
does that make sense? I think I saw a macro for this before...