Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Copy data in Excel rows to formulas in columns

Posted on 2015-01-09
1
Medium Priority
?
87 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 27

Accepted Solution

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

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

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

: 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…
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
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.

824 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