Trying to input data from columns in cell

		Microsoft Office Forums > Microsoft Excel > Excel
Trying to input data from columns in cell

FAQ

Thread Tools

Display Modes

07-30-2013, 11:28 AM

Pecoflyer

Windows 7 64bit Trying to input data from columns in cell

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

Hi
you can use the TRANSPOSE function to that effect
Also review the INDEX syntax

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Tags

formula, help please, rows and columns

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to input the text of a cell into another cell automatically ？	Juliet	Excel	1	03-15-2013 03:25 AM
how to input data vertically in spreadsheet?	mikehende	Excel	3	10-10-2012 11:40 PM
how to write G1 in terms of B1+value in the cell 5 columns away (which is G1 itself))	Sunny	Excel	3	04-20-2012 12:32 AM
Data input in Powerpoint?	DeeDubb	PowerPoint	1	04-05-2012 01:53 AM
Move data from 1 cell to another cell	Catalin.B	Excel	1	06-25-2011 12:51 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:49 AM.