Excel Query

Excel Help for Excel Query in Analyzing Corporate Financial Data

Excel Query

Rate this: (3/5 from 1 vote)

	Hi 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 12james on 04 Jul 2010

Replies - Displaying 1 to 1 of 1

Order Replies By: Most recent | Chronological | Highest Rated

	Transpose cells 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 Excel Helper on 05 Jul 2010

Displaying page 1 of 1