Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #16  
Old 05-31-2020, 07:12 AM
p45cal's Avatar
p45cal p45cal is offline Check multiple cafeterias Windows 10 Check multiple cafeterias Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

Oh gosh. a big question; many things can vary. The trite answer is to go and get yourself a primer on Power Query, or find an online tutorial.

You could try and copy your real data onto the existing table, it should automatically expand to accommodate the new data (make sure it keeps the same table name as I used), then try and refresh - you might be lucky, otherwise, supply a workbook with a larger set of colums (it doesn't need to all 3000 rows, just enough to give a valid results table (50-100 rows?).




As far as new/future projects are concerned, then it's my trite answer I'm afraid. For me to try and explain all the steps taken it's going to be virtually the same as a tutorial and I'm just not prepared to give the oodles of time it will need.
Reply With Quote
  #17  
Old 06-02-2020, 11:29 AM
OCM OCM is offline Check multiple cafeterias Windows 7 32bit Check multiple cafeterias Office 2000
Novice
Check multiple cafeterias
 
Join Date: Mar 2013
Posts: 17
OCM is on a distinguished road
Default

P45cal,thanks.

I did try copying my real data onto the existing table w/o any success.
Attached is a sample data (a strip down version). Sheet2 is the expected result.
Over the weekend, I watched few introductions to power query videos. But, I’ve yet to learn enough to apply it to what I’m trying to accomplish.

TIA

Regard,
Attached Files
File Type: xlsx Example mod.xlsx (18.5 KB, 5 views)
Reply With Quote
  #18  
Old 06-03-2020, 06:31 AM
p45cal's Avatar
p45cal p45cal is offline Check multiple cafeterias Windows 10 Check multiple cafeterias Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

In the attached is a table produced by Power Query at cell A21 of Sheet2.
From that table is a pivot table at cell N1

Power Query will allow you to bypass the visible table at cell A21 and produce a pivot table directly (it means you don't need to see the source table for the pivot at all).


What worries me slightly is that your most recent file only contains column A to I whereas you've said your actual workbook contains column A to X, so you'll be asking for further alterations…
Attached Files
File Type: xlsx msofficeforums44954Example mod_dev03.xlsx (33.6 KB, 8 views)
Reply With Quote
  #19  
Old 06-03-2020, 12:52 PM
p45cal's Avatar
p45cal p45cal is offline Check multiple cafeterias Windows 10 Check multiple cafeterias Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

You may be interested in a glitch I encountered: FillDown is also doing unwanted row re-arranging
Reply With Quote
  #20  
Old 06-03-2020, 06:25 PM
OCM OCM is offline Check multiple cafeterias Windows 7 32bit Check multiple cafeterias Office 2000
Novice
Check multiple cafeterias
 
Join Date: Mar 2013
Posts: 17
OCM is on a distinguished road
Default

p45cal

Thank you for the revision and solution to my post. This is exactly what I was trying to accomplish. As for the number of columns, I removed irrelevant columns to simplify things and it's going to stay this way.

Thank you for sharing the discussion about fill down in excelguru. I never experienced this issue before, but I found the discussion to be very educational.

My goal moving forward is to learn power query and power BI as much as possible.

Many thanks!

Reply With Quote
  #21  
Old 06-04-2020, 03:52 AM
p45cal's Avatar
p45cal p45cal is offline Check multiple cafeterias Windows 10 Check multiple cafeterias Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

re: Check multiple conditions - Microsoft: Office - Tek-Tips


please, again, read Excelguru Help Site - A message to forum cross posters


'again'? see https://www.msofficeforums.com/113114-post3.html
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Select multiple check boxes at once. Batchook Word 0 09-08-2016 03:44 PM
Check multiple cafeterias Excel vba to check to check if two columns are empty subspace3 Excel Programming 5 07-09-2015 04:45 PM
Multiple Check In/check Out Times big0 Excel 4 09-19-2013 05:02 AM
Check multiple cafeterias cannot check/uncheck check box but added check box learn2office Word 1 11-27-2012 02:02 AM
Link word check box to access check box Mrkieth Word 4 01-30-2012 06:43 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:01 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