Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 9
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 9
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
delete cells column. Delete empty cells myshak Excel Worksheet Functions 0 March 9th 09 11:59 PM
How do I delete everything after a / in a column? henderson Excel Worksheet Functions 17 July 19th 07 06:55 PM
delete duplicates in column not the row Wanna Learn Excel Discussion (Misc queries) 0 June 6th 07 03:08 PM
how to delete 1 item in colum jarcher06 Excel Discussion (Misc queries) 2 March 18th 07 10:11 PM
CANNOT DELETE AN ENTIRE COLUMN ibeetb Excel Discussion (Misc queries) 4 June 23rd 06 02:55 AM


All times are GMT +1. The time now is 01:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"