Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Copy data in Excel rows to formulas in columns

Posted on 2015-01-09
1
74 Views
Last Modified: 2015-01-14
We have a spreadsheet with massive data based in rows like this:
Item 1, a, b, c, d, e, f, g
Item 2, h, i, j, k, l, m, n
Item 3, o, p, q, r, s, t, u

We want to formulaically transpose the data onto another sheet, but in columns (not copy/paste)

Item 1, Item 2, Item 3
a, h, o
b, i, p
c, j, q
d, k, r
e, l, s
f, m, t
g, n, u

Looking for help on writing that formula so that it can be easily copied
0
Comment
Question by:M_Patton
1 Comment
 
LVL 26

Accepted Solution

by:
ProfessorJimJam earned 500 total points
ID: 40540775
FIND ATTACHED.
EE.xlsx
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Google sheet call expression from IF statement 1 55
excel 2013 substitute function 8 93
Excel 2010 - Formula to show Max of values 11 65
Earnings Spreadsheet in Excel 3 78
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
: Microsoft Office Collaborate for free and online versions of Microsoft  Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by  Micr…
Viewers will learn various types of data validation for different data types in Excel 2013.
Viewers will learn the basics of printing in Excel 2013 and how to adjust some common settings.

789 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question