Results 1 to 2 of 2

Thread: Based on cell value in column 1, rearrange 'content blocks' from a vertical to horizontal position
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jun 2014
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Based on cell value in column 1, rearrange 'content blocks' from a vertical to horizontal position

    Goodday everyone.

    I am preparing data to backtest a sector rotation momentum investing strategy, which is a part of my research project. For this I use intraday data. However, the query does (of course) not arrange the output like I would want it to.

    I have found a macro that adds a based on a change of cell value in column 1, and now my data looks like this:


    I want it to look like this:


    Normally I would just do this by hand.. But now I have to do this for 600 companies, in a separate sheet for every trading day of the year (252), for 8 years. That would be copying and pasting a 1.209.600 times. Can someone help me out? Or point me in the right direction?

    Thanks!

  2. #2
    New Member
    Join Date
    Jun 2014
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Based on cell value in column 1, rearrange 'content blocks' from a vertical to horizontal position





Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •