Id like to know how to write a macro that takes a single column and then turns X number of rows into a single line, then repeats this action for the entire spreadsheet (to save someone from running this over 30,000 cells)
say I want it to select column C, but and concatenate every 5 lines into a single line.
Then I'd have it output as new rows, containing those 5 pieces of data
I dont have any code, unfortunately (Im not a programmer, so bear with me here). From my understanding, it would use something similar to this, but include a for-loop somewhere to repeat the action until the end of the document, which is what Im confused with the most.
Thanks in advance and apologies for any confusion!