Move all data from selected rows, into the top most selected row.

[Travis Kunnen]

Hi All

Another problem.

Im seeking a function or macro to move all the data from a selected series of rows, into the top most row of the selected area.
Example below. There are 12 rows of Romboutsia (84 to 95), and all rows will (/should) have 1 data point. Im looking to move all the data from the selected rows, into the top most row for this group. So the data from C87, needs to move into C84, D90 into D84, E93 into E84, etc etc...
There will never be two sets of data in the rows, for the same selected grouping of names from column A.
Then I can repeat the process for the next set, the Ruminococcus, and so on and so forth....

Macro Top 20.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M
84	Romboutsia	0,0872162
85	Romboutsia					0,02813
86	Romboutsia									0,03553
87	Romboutsia		0,077430923
88	Romboutsia						0,21361
89	Romboutsia										0,11849
90	Romboutsia			0,047901507
91	Romboutsia							0,032
92	Romboutsia											0,01558
93	Romboutsia				0,02124862
94	Romboutsia								0,02868
95	Romboutsia												0,0124
96	Ruminococcus	0,01897662
97	Ruminococcus		0,014345097
98	Ruminococcus			0,014001448
99	Ruminococcus							0,0106
Layer 1

 

[Travis Kunnen]

Your image post looks correct.

I dont follow your question.
Column A has only bacterial genus names, that are either as single names for 1 row of data, or multiple rows (of the same genus) for multiple rows of data from different sample types and locations for where they were identified.
So Column A is always genus name, and then the numerical data always starts in column B till G, or H, etc. But here its only 8 columns of numerical data.

 

[jolivanes]

You have a quantity of names of which some are repeated. Are these repeated same names all in a single block, are they under one another without any other names in this block of names?
For instance if you have AAA as a name and it is repeated 4 times so you'd have Cells A10, A11, A12, A13 and A14 all with AAA. Would AAA show up later again like in A16 or A24?

You might find out if you sort on Column A and run the macro again.

 

[Travis Kunnen]

Ah, I see what you're asking.
Yes, they do show up randomly throughout the database, but I do sort them alphabetically in my data file before I do any work on them or run a macro on them.
I will run yours again tomorrow to double check.

 

[rpaulson]

i can tweet my code for you.

if i understand.
1. sort the list by column A so all the Genus are in order.
2. move all data for the first row of each Genus (this already works)
3. delete the remained rows within that genus, leaveing only one row per Genus.
-Ross

 

[jolivanes]

Re: "Yes, they do show up randomly throughout the database"
OK, but that did not show in your original Post and that's what I went by.
If there are no 2 entries in one Column for one name, the code should work after sorting Column A