Home > Forum Home > Analyzing Corporate Financial Data > Excel Query Share

Excel Query

Excel Help for Excel Query in Analyzing Corporate Financial Data


Forum TopicPost Reply Login

Excel Query

Rate this:
(3/5 from 1 vote)
ConfusedHi

I have data that comes out in address1 and address2 in seperate rows but I need to format it into columns1 and column 2.

Any ideas how or a formula to assist.
 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most Recent | Chronological | Highest Rated
Shocked
Rate this:
(3/5 from 1 vote)
To convert data in rows to columns, you can Copy and Paste special > and choose 'Transpose' as an option. This can also be done using VBA code if more complexity is required in the data layout transformation.
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Excel templates and solutions matched for Excel Query:

Solutions: Database Report Builder ODBC SQL Query Report Builder Database Manager Relational Database SQL Statements Smartphone Database Query