Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 12-16-2018, 02:29 AM
hiwire03 hiwire03 is offline Windows 7 32bit Office 2013
Novice
 
Join Date: Dec 2014
Posts: 11
hiwire03 is on a distinguished road
Default Rearranging Data Table

Trying to figure out a formula to rearrange data in the existing table to the desired table. Tried the 'Manage Data Model' but was unable to figure it out. Any guidance is highly appreciated.
Attached Images
File Type: jpg Capture.JPG (46.2 KB, 14 views)
Reply With Quote
  #2  
Old 12-16-2018, 04:33 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,381
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Please post a sample sheet. We cannot work on an image. Thanks
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
  #3  
Old 12-16-2018, 04:52 AM
hiwire03 hiwire03 is offline Windows 7 32bit Office 2013
Novice
 
Join Date: Dec 2014
Posts: 11
hiwire03 is on a distinguished road
Default

Quote:
Originally Posted by hiwire03 View Post
Trying to figure out a formula to rearrange data in the existing table to the desired table. Tried the 'Manage Data Model' but was unable to figure it out. Any guidance is highly appreciated.
The concept in essence is the reversing of the pivot table. Found the solution here https://www.youtube.com/watch?v=pUXJLzqlEPk

(Just for everyones benefit)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Rearranging the styles in the ribbon? seanspotatobusiness Word 2 01-16-2017 12:33 PM
Rearranging pages by Order No after merge blackystrat Mail Merge 1 12-11-2015 01:43 PM
use existing table data and not get generic excel chart data canar Word Tables 3 09-08-2015 03:36 PM
Rearranging components of SmartArt Graphic seanspotatobusiness PowerPoint 0 04-01-2014 05:35 AM
Macro for tagging and rearranging selected text for revision caotico Word VBA 0 03-28-2012 06:35 PM


All times are GMT -7. The time now is 08:30 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft