ThrottleWorks
Excel Ninja
Hi,
I have a data. There are around 50 columns and 150 rows in this data.
Number of rows will vary but no of columns will remain same.
In this data, in column D, I have account numbers. This numbers are reflecting multiple times in this data. Column D is sorted from A to Z. That is why, duplicate account numbers are populated in serial order.
For example, if account number ABC 123 is repeated twice, it will be reflected in serial order, let’s say row 2 and 3.
Can we segregate duplicate account numbers.
I do want duplicate account numbers in serial order. If account ABC 123 is as row 2 then next instance should not be at row 3. Next instance of account ABC 123 should be populated anywhere after row 3 but not in row 3.
So, original order is, row 2 = ABC 123, row 3 = ABC 123, row 4 XYZ 123.
I want a solution which will re-shuffle data in following way.
row 2 = ABC 123, row 3 = XYZ 123, row 4 ABC 123.
Can anyone please help me in this.
I have a data. There are around 50 columns and 150 rows in this data.
Number of rows will vary but no of columns will remain same.
In this data, in column D, I have account numbers. This numbers are reflecting multiple times in this data. Column D is sorted from A to Z. That is why, duplicate account numbers are populated in serial order.
For example, if account number ABC 123 is repeated twice, it will be reflected in serial order, let’s say row 2 and 3.
Can we segregate duplicate account numbers.
I do want duplicate account numbers in serial order. If account ABC 123 is as row 2 then next instance should not be at row 3. Next instance of account ABC 123 should be populated anywhere after row 3 but not in row 3.
So, original order is, row 2 = ABC 123, row 3 = ABC 123, row 4 XYZ 123.
I want a solution which will re-shuffle data in following way.
row 2 = ABC 123, row 3 = XYZ 123, row 4 ABC 123.
Can anyone please help me in this.