Solved

Copy data in Excel rows to formulas in columns

Posted on 2015-01-09
1
71 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 25

Accepted Solution

by:
ProfessorJimJam earned 500 total points
Comment Utility
FIND ATTACHED.
EE.xlsx
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
Viewers will learn the basics about Excel 2013’s new Flash Fill feature.
Viewers will learn how to share Excel data with others from desktop Excel, as well as Excel Online via OneDrive, and embed an Excel file on a website.

744 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now