Search code examples
excelexcel-formulaexcel-2007

Move Data in Vertical Cells To Horizontal Cells in Excel 2007

I am using excel 2007

I have a excel sheet with around 1200 records with following structure...

WHAT CAN BE EASIEST WAY TO DO THIS ?

For easy understanding, Adding image :

enter image description here

Solution

  • Formula Used as follows (Giving solution here so in future members can use it)

    The formula is : In empty cell after Treasurer Column,

     =If($a2="","",a2) // copy over next 4 columns to give the District, Branch, Pre name, address, mobile elements as =If($a2="","",a2), =If($b2="","",b2), =If($c2="","",c2), =If($c2="","",c3), =If($c2="","",c3), =If($c2="","",c4)

 =if($d2="","",d2) // copy over next 2 columns for Secretary details like =if($d2="","",d2), =if($d2="","",d3), =if($d2="","",d4)

 =if($g2="","",g2) // copy over next 2 columns for Treasurer details like =if($g2="","",g2), =if($g2="","",g3), =if($g2="","",g4)

    Now Select All New Formula Cells in a row after Treasurer column >> Drag Down Till All Records....

    Then Copy all these down to the bottom of your data

    Either copy / paste special >> values to somewhere else and

    Then sort by District / Branch / Pres to drop the blank rows