excel vba copy paste cells into respective columns : I have an excel 2007 sheet where column names with data are all placed in one single column and I need to shift one column name to the left or right with data so that I can have separate columns. Can you create a VBA function where it reads all rows of the column and shift those columns with certain keywords. such as:

    A1   B1
    1     **Category1**
          Cat1 info here
          **cf**
          45
          34
          34
          Sf
          542
          234
          234
    2     **Category2**
          Cat2 info here
          **cf**
          76
          23
          67
          **Sf**
          678
          987
          3476

 I Need to move "**cf**" column + data to a different column and paste it to its relevant category. So Cf would shift right with data and move up along with its category. I would then delete the empty rows of B Column.