Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-31-2012, 10:39 AM
ItsjustB ItsjustB is offline Transpose cells and skip? Windows XP Transpose cells and skip? Office 2007
Novice
Transpose cells and skip?
 
Join Date: Dec 2012
Posts: 1
ItsjustB is on a distinguished road
Default Transpose cells and skip?

In the attached workbook I need to transpose some data AND skip cells as I do so. For example, the data for Sheet2!B4 is contained in Sheet1!A5, and the data for Sheet2!B5 is in Sheet1!B5.

Then the data for Sheet2!C4 is in Sheet1!C5, and the data for cell Sheet2!C5 is in Sheet1!D5.

This continues on for a whole bunch of cells (eventually the entire table in Sheet2 will be filled; I deleted a bunch of data from Sheet 1 for readability) or I'd just do this manually.

May I get some suggestions for how to do this with a minimum of pain? I was thinking of mapping cells (Sheet2!B4 =Sheet1!A5, Sheet2!B5 =Sheet1!B5) and then filling the series for the rest of the cells but I can't get Excel to understand the pattern?

Thanks in advance.
Attached Files
File Type: xlsx Example.xlsx (11.4 KB, 9 views)
Reply With Quote
  #2  
Old 01-09-2013, 08:53 AM
OTPM OTPM is offline Transpose cells and skip? Windows 7 32bit Transpose cells and skip? Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi
The easiest way to achieve what you want is to transpose your source data from columns to rows.
Then use your formula as normal i.e. =Sheet1!C5 and then drag it down your target column and it will pick up the correct values from your source data.
Good luck.
Tony
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Transpose cells and skip? Transpose Issue (need custom increment on auto fill down) gretchen Excel 3 11-28-2012 02:33 PM
How to transpose the datas of part code and supplier into row and column PRADEEPB270 Excel 3 10-26-2012 07:22 PM
Transpose cells and skip? skip to next sentence? moreenz Word 3 08-16-2012 02:41 PM
Transpose cells and skip? skip duplicate letters karen h Mail Merge 10 03-23-2011 08:37 AM
How to skip the credential checking step charleslt1900 Outlook 2 08-19-2010 04:02 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:33 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft