当前位置: 动力学知识库 > 问答 > 编程问答 >

Excel Macro to merge a number of rows and output in a single line

问题描述:

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!

分享给朋友:
您可能感兴趣的文章:
随机阅读: