Help sorting CSV file

[igl00]

its propably or possibly easy, but ive no idea how to handle it.

i have a csv with top10 for a keyword. thing is the top10 goes horizontally not vertically.
so each cell is 1, 2 ,3 4 etc, then it starts again. so its
top10
top10
top10

for like 30 days. id like to sort it our horizontally, so each row would be other top10 so they are easy to compare.

any help appreciated.

 

[arxs]

read your question, couldn't understand most of it.

copy -> paste special -> transpose?

 

[igl00]

ok to make it more clear.
top1
top2
top3
top4
top5
top6
top7
top8
top9
top10
top1
top2
top3
top4
top5
top6
top7
top8
top9
top10
top1
top2
top3
top4
top5
top6
top7
top8
top9
top10

so shortyl:
top10
top10
top10

instead of that i want to have:
top10,top10,top10


theres more than 3 rows/cells.

 

[arxs]

That's even more confusing.

I give up - you are making me dizzy

 

[igl00]

That's even more confusing.

I give up - you are making me dizzy

made it by using stackoverflow and put new post on blog.
thanx for help, and hope i helped u get good dreams by making u dizzy!

 

[gutterseo]

You need to use regex to solve this problem.

 

[igl00]

You need to use regex to solve this problem.

ya i did that in php on the end but was hopin this can go easier somehow.
for now ive put 3 files on blog with top10 ranks with hummingbird/penguin2.1 changes inbetween. heres ie buy tramadol [right clic kto save].

 

[bigot]

I'd like to help, but I am unclear on the question. I've taken a look at your xls file and it has clarified it for me a bit.

Correct me if I'm wrong: Each column has a keyword associated with it. A list of 10 - 20 websites is set in each column.

Something like this?

Keyword #1 | Keyword #2 | Keyword #3 | ... | Keyword #n
kwd1-site1 | kwd1-site2 | kwd1-site3 | ... | kwd1-siten
kwd2-site1 | kwd2-site2 | kwd2-site3 | ... | kwd2-siten
kwd3-site1 | kwd3-site2 | kwd3-site3 | ... | kwd3-siten
kwd4-site1 | kwd4-site2 | kwd4-site3 | ... | kwd4-siten



What do you want to do exactly? Move them all to a single column?


kwd1-site1
kwd1-site2
kwd1-site3
kwd1-site4
kwd2-site1
kwd2-site2
kwd2-site3
...

 

[phrench]

Igloo, wtf you have your VA for? Give her to me!

 

[Nerd Muscles]

1. copy all your data to clipboard
2. click new sheet
3. right click first cell
4. under 'paste options' select 'transpose'