1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Help with csv/excell macro.

Discussion in 'BlackHat Lounge' started by iglow, Oct 22, 2013.

  1. iglow

    iglow Elite Member

    Joined:
    Feb 20, 2009
    Messages:
    2,080
    Likes Received:
    856
    Home Page:
    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.


    to make it 'visual':
    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 shortly:
    top10
    top10
    top10

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


    theres more than 3 rows/cells.


    any help appreciated.
     
  2. RosuC

    RosuC Regular Member

    Joined:
    Oct 9, 2012
    Messages:
    263
    Likes Received:
    112
    Location:
    Spain
    Home Page:
    Is a bit hard to make that automatically because Excel knows the Row/Column - now as far as I see you have on a Column some information that you want to be transferred on a row. I can be done with the ROW() or COLUMN() Formula but I don't think that will make it automatically. I can help more if I have a sample of your .XLS or .CSV file - maybe I can sort it out somehow. I've tried long time ago to make something similar but it was always getting back to manual work :(