<div>
That's got to be a record response time - many thanks to you both - easy when you know how!
</div>


That's got to be a record response time - many thanks to you both - easy when you know how!

<div>
<div class="content wysiwyg-content">
Firstly I have no idea if this is possible and was hoping there might be a simple(ish) solution!<br />
<br />
I have been supplied a spread sheet that I need to import into ms/my sql with a list of companies and what they do.<br />
<br />
Currently the companies are in the columns and what they do in the rows.<br />
<br />
I need to have the companies in the row, with what they do in the columns.<br />
<br />
In essence rotating it through 90 degrees.<br />
<br />
Hoping someone can help - many thanks in advance<br />
<br />
Grant<br />
<br />
<br />
<br />

</div>
</div>


Firstly I have no idea if this is possible and was hoping there might be a simple(ish) solution!

I have been supplied a spread sheet that I need to import into ms/my sql with a list of companies and what they do.

Currently the companies are in the columns and what they do in the rows.

I need to have the companies in the row, with what they do in the columns.

In essence rotating it through 90 degrees.

Hoping someone can help - many thanks in advance

Grant





Rotating an excel spread sheet - swapping columns &amp; rows

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

Microsoft Excel

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

Rotating an excel spread sheet - swapping columns &amp; rows

Rotating an excel spread sheet - swapping columns & rows