Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Copy column header to next column, delete & delete every nth colum
Well SNPid Call SamID Well SNPid Call SamID Well SNPid Call SamID
A01 rs10090154 C 1 A01 rs1016343 C 1 A01 rs10486567 AG 1 A02 rs10090154 C 2 A02 rs1016343 TC 2 A02 rs10486567 AG 2 A03 rs10090154 C 3 A03 rs1016343 TC 3 A03 rs10486567 G 3 Hi, My workflow was dramatically streamlined thanks to a previous question posted and the generous reply and help of members here. I have another step in my data-cleanup that requires reformatting my excel table and I would be very appreciative if I can get some help. I myself do not have the Visual Basic abilities to do this. Here is the table structure and data Well SNPid Call SamID Well SNPid Call SamID Well SNPid Call SamID A01 rs10090154 C 1 A01 rs1016343 C 1 A01 rs10486567 AG 1 A02 rs10090154 C 2 A02 rs1016343 TC 2 A02 rs10486567 AG 2 A03 rs10090154 C 3 A03 rs1016343 TC 3 A03 rs10486567 G 3 There are 4 columns that keep repeating itself for many many times. The columns are in the order : Col A:Well Col B:SNPid Col C:Call Col D:SamID and so on.... I would like to be able to do the following: (1) I want that for every Col with the header SNPid [example col B and ColB + 4 (every 4th column) ...and so on) to be copied to Col C and Col C+4 (every 4th column) and so on...] (2) Then I want Col B and Col B +4 and (every 4th column from there) and so on to be deleted. (3) I also want every column with the Well and SamID to be deleted. However I want the first occurence of these to be not deleted. Meaning.. Well (Col E, Col I, Col M and so on.. as well as SamID Col H, Col L, Col P and so on to the end to be deleted. Kindly help, Thanks ~GH The final table would want to look like this Well Samid rs10090154 rs1016343 rs10486567 A01 1 C C AG A02 2 C TC AG A03 3 C TC G A04 4 C C AG |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Copy column header to next column, delete & delete every nth colum
I realized that if I can get the Col B2 andevery 4th column, row2 to be
copied to C2 and every 4th column row2 from C, then I can do a left to right sort and delete everything. So if I can get the first part to be done with a macro.. that will be great! Thanks ~GH |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
delete cells column. Delete empty cells | Excel Worksheet Functions | |||
How do I delete everything after a / in a column? | Excel Worksheet Functions | |||
delete duplicates in column not the row | Excel Discussion (Misc queries) | |||
how to delete 1 item in colum | Excel Discussion (Misc queries) | |||
CANNOT DELETE AN ENTIRE COLUMN | Excel Discussion (Misc queries) |