问题描述:

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)

For example,

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!

相关阅读:
Top