Transform-fours.xls

<div>
If you want to have VBA then you can use<br />
<br />
Sub transform4()<br />
For Each cel In Sheet1.Columns(1).Cells<br />
If cel.Value = &quot;&quot;&nbsp;Then End<br />
Sheet2.Cells(Int((cel.Row - 1) / 4) + 2, (cel.Row - 1) Mod 4 + 1) = cel.Value<br />
Next cel<br />
End Sub<br />
<br />
<br />
The results would be on sheet2
</div>


If you want to have VBA then you can use

Sub transform4()
For Each cel In Sheet1.Columns(1).Cells
If cel.Value = "" Then End
Sheet2.Cells(Int((cel.Row - 1) / 4) + 2, (cel.Row - 1) Mod 4 + 1) = cel.Value
Next cel
End Sub


The results would be on sheet2

<div>
<div class="content wysiwyg-content">
Hi all<br />
<br />
I have a need to re-arrange the data set.. see attached figure..<br />
The data are arranged by Yearly Quartal..<br />
i.e starting from 1901(4 data set); 1902 (4 &nbsp;data set) etc..<br />
I am looking for a formular or a tutoiral that will help me <br />
re-arrange them in columns i.e<br />
<br />
Ist Quarter; Second Quarter; Third Quarter; Last Quarter; and Year<br />
1.55946; &nbsp; &nbsp; &nbsp;1.585132; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1.78814; &nbsp; &nbsp; 1.8174; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1901<br />
<br />
etc..<br />
<br />
Thanks your help will be appericated..<br />
<br />
Regards<br />
&nbsp;<a href="https://filedb.experts-exchange.com/incoming/2011/04_w18/449282/Excel.jpg" target="_blank" title="Transformation Horizontal to vetical (48 KB)"><img alt="Transformation Horizontal to vetical" class="file-block lazyload" style="max-width: 399px;" data-src="https://filedb.experts-exchange.com/incoming/2011/04_w18/449282/Excel.jpg" /></a>
</div>
</div>


Excel.jpg

Hi all

I have a need to re-arrange the data set.. see attached figure..
The data are arranged by Yearly Quartal..
i.e starting from 1901(4 data set); 1902 (4  data set) etc..
I am looking for a formular or a tutoiral that will help me 
re-arrange them in columns i.e

Ist Quarter; Second Quarter; Third Quarter; Last Quarter; and Year
1.55946;      1.585132;            1.78814;     1.8174;               1901

etc..

Thanks your help will be appericated..

Regards
 

Transform Horizontal data to vertical Column

A programming language is a formal constructed language designed to communicate instructions to a machine, particularly a computer. Thousands of different programming languages have been created, mainly in the computer field, and many more still are being created every year. The description of a programming language is usually split into the two components of syntax (form) and semantics (meaning). Some languages are defined by a specification document (for example, the C programming language is specified by an ISO Standard), while other languages (such as Perl) have a dominant implementation that is treated as a reference. Some languages have both, with the basic language defined by a standard and extensions taken from the dominant implementation being common.

Programming Languages-Other

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.