LinkBack URL
About LinkBacks
Hi,
Everyone always want to get rid of duplicate rows.
Is it possible to create duplicate rows of all the existing rows?
Cheers.
Hi,
Everyone always want to get rid of duplicate rows.
Is it possible to create duplicate rows of all the existing rows?
Cheers.
Yes,
Just copy them and paste back somewhere else - either as values (converting formulas to actual values) or as is.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
The thing is that it is a time value running sequentially at the moment.
Ex:
A
B
C
D
I want it to be:
A
A
B
B
C
C
D
D
Cheers.
Is this OKIE?
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 * +++
Thanks. Working!!
Richard Buttrey is rightly said, just copy and paste at end of the record and sort will resolve but i have a purpose if we able to identify sheet2 column a1 field and find in sheet1 A:A, then create duplicate rows for such identified field then that will help me a lot.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks