i Have excel sheet with many thousands of rows and they are in only one column. I want to merge every 10 rows into one row.
Means, if i have totally 100 rows then it should be fix in 10 rows only. Waiting for answers. Thank in advance dudes........
i Have excel sheet with many thousands of rows and they are in only one column. I want to merge every 10 rows into one row.
Means, if i have totally 100 rows then it should be fix in 10 rows only. Waiting for answers. Thank in advance dudes........
Change the 100 to max row you need, and run the macro.Please Login or Register to view this content.
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
Please Login or Register to view this content.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
1st code is not working.
2nd code working but not which i thought. Most of my problem solved here.
i made some more excel copy paste and applied formulas after performing 2nd code.
Thank you very much for the 2 coders......... Thanks again.......... love u.
Okay, thanks for feedback.
I believe i totally misunderstood your requirement, after look at Special-K code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks