#16
|
||||
|
||||
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. |
#17
|
|||
|
|||
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, |
#18
|
||||
|
||||
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… |
#19
|
||||
|
||||
You may be interested in a glitch I encountered: FillDown is also doing unwanted row re-arranging
|
#20
|
|||
|
|||
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! |
#21
|
||||
|
||||
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Select multiple check boxes at once. | Batchook | Word | 0 | 09-08-2016 03:44 PM |
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 |
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 |