Posted 8 September 2017, 1:09 pm EST
I am displaying some items and their rank in a spread sheet from a data source. Some items has a rank value and Rank column is merged. That means for one Itemid there are 5 items and for another 4 items, and 4 rows for anothe itemid with rank 1,2,and 3 respectively. Like below the items are listed.
ItemID | Rank
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
100 | 1
102 | 2
103 | 3
I want to move the item with id 100(that means 3 rows at a time) to a position after itemid 102( not in the middle of 102, that means after last item with id 102).
So how to select all three rows and move multiple rows.
If anybody has a solution for this please reply ASAP..
Please reply with an example.
Thanks in Advance