Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-16-2018, 02:29 AM
hiwire03 hiwire03 is offline Rearranging Data Table Windows 7 32bit Rearranging Data Table Office 2013
Novice
Rearranging Data Table
 
Join Date: Dec 2014
Posts: 17
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, 20 views)
Reply With Quote
  #2  
Old 12-16-2018, 04:33 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Rearranging Data Table Windows 7 64bit Rearranging Data Table Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,771
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Please post a sample sheet. We cannot work on an image. Thanks
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 12-16-2018, 04:52 AM
hiwire03 hiwire03 is offline Rearranging Data Table Windows 7 32bit Rearranging Data Table Office 2013
Novice
Rearranging Data Table
 
Join Date: Dec 2014
Posts: 17
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



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 Data Table Rearranging pages by Order No after merge blackystrat Mail Merge 1 12-11-2015 01:43 PM
Rearranging Data Table 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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:04 PM.


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