Hi--I'd like to arrange a sheet so that rows that have the same value in column D appear together after the first occurrence of that value. I don't want it alphabetical. Attaching two sheets--Starting A is a sample of how it is and Result B is how I would like it--obviously at a much larger scale! Appreciate any help!
Re: Rearranging a sheet so that rows that have the same value in column D appear together
is that what you want?
in your output you have redundant one row (duplicate)
Column1 Column2 Column3 Column4 Column5 Column6 Column7 Column8 Latin C010L01 carrots Latin C01L01 carrots Latin C01L03 carrots Latin C010L03 bananas Latin C02L01 bananas Latin C010L04 kiwis Latin C01L02 kiwis Latin C010L02 apples Latin C01L04 apples
with Power Query
Please Login or Register to view this content.
Last edited by sandy666; 01-11-2023 at 06:50 PM.
The sample was just a simple example to demonstrate the organization.
sure, add more data into source table then refresh green table (right click and refresh or Ctrl+Alt+F5) but if there will be more different words in column4 you'll need to add more conditions
Oh, sorry--my first reply got eaten. The problem is that there are about 20,000 rows and many different possibilities for what the name in Column 4 will be. I just used those as samples to show the organization. I think I need something very general, if it's even possible. I can't list all the conditions.
no problem just add list of your words in column4 in proper order, will be much easier
edit:
and post more representative example with list of your words
something like this
source table
Column1 Column2 Column3 Column4 Column5 Column6 Column7 Column8 list Latin C010L01 carrots carrots Latin C010L02 apples bananas Latin C010L03 bananas kiwis Latin C010L04 kiwis apples Latin C01L01 carrots Latin C01L02 kiwis Latin C01L03 carrots Latin C01L04 apples Latin C02L01 bananas
Last edited by sandy666; 01-11-2023 at 07:20 PM.
Re: Rearranging a sheet so that rows that have the same value in column D appear together
or try this
just paste more data into source table, complete the list then go to the green table and refresh
you are limited to excel sheet capacity only (1,048,576 rows)
Last edited by sandy666; 01-11-2023 at 08:07 PM.
you can do that, select whole column with words, copy and paste into another place then from the ribbon choose Remove Duplicates then set the order if necessaryOriginally Posted by kitkat23
Got it! Thank you so much! This answered my query.
You are welcome
if the problem is solved, hit Add Reputation (bottom left corner next to the post that was helpful)
and then mark the thread as SOLVED (top above your first post - Thread Tools)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks