NormalizerQ28265702.xlsm

<div>
byundt - this worked beautifully. I adjusted it to fit the number of columns my data had and ran it this morning. Thank you very much for the help. This has saved me a significant amount of time. I have a few more tweaks to make to my spreadsheet in order to call it complete but this got me 80 % there.
</div>


byundt - this worked beautifully. I adjusted it to fit the number of columns my data had and ran it this morning. Thank you very much for the help. This has saved me a significant amount of time. I have a few more tweaks to make to my spreadsheet in order to call it complete but this got me 80 % there.

<div>
<div class="content wysiwyg-content">
I have data that looks like this in Excel<br />
<br />
name &nbsp; &nbsp; &nbsp;status &nbsp; &nbsp; column1 &nbsp; &nbsp; column2 &nbsp; &nbsp; &nbsp;column3<br />
<br />
I need the data to be transformed into<br />
<br />
name &nbsp; &nbsp;status &nbsp; &nbsp; column1<br />
name &nbsp; &nbsp;status &nbsp; &nbsp; column2<br />
name &nbsp; &nbsp;status &nbsp; &nbsp; column3<br />
<br />
The file has 75 rows and 34 columns that need to be transposed.
</div>
</div>


I have data that looks like this in Excel

name      status     column1     column2      column3

I need the data to be transformed into

name    status     column1
name    status     column2
name    status     column3

The file has 75 rows and 34 columns that need to be transposed.

Normalize Excel data

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.