# Search:

Type: Posts; User: sandy666; Keyword(s):

Page 1 of 6 1

1. ## Thread: power query running total help

by sandy666
Replies
3
Views
111

### Re: power query running total help

or try

Running Total in PQ
2. ## Thread: power query running total help

by sandy666
Replies
3
Views
111

### Re: power query running total help

expected result example?
3. ## Thread: populate cells using

by sandy666
Replies
6
Views
70

### Re: populate cells using

maybe something like this with PivotTable

Count of CourseCourse

StudentIDEnglishFrenchMathScience

a1
1
1
4. ## Thread: New Group of Rows to a Table

by sandy666
Replies
6
Views
84

### Re: New Group of Rows to a Table

you can try PowerQuery (Get&TRansform)

// WChart_Data
let
Source1 = Excel.CurrentWorkbook(){[Name="WChart_Data"]}[Content],
Source2 =...
5. ## Thread: New Group of Rows to a Table

by sandy666
Replies
6
Views
84

### Re: New Group of Rows to a Table

this is simply copy/paste and nothing to expand or I don't understand your logic
6. ## Thread: New Group of Rows to a Table

by sandy666
Replies
6
Views
84

### Re: New Group of Rows to a Table

it seems like you want duplicate 12 last rows, am I right?

by sandy666
Replies
3
Views
45

### Re: Countifs formula

sure

have a nice day

by sandy666
Replies
3
Views
45

### Re: Countifs formula

maybe ">="&AB4
9. ## Thread: Sorry, We couldn't find...

by sandy666
Replies
1
Views
66

### Re: Sorry, We couldn't find...

try PowerQuery (Get&Transform) with From Folder feature
10. ## Thread: VLOOKUP help (not SUMIF)

by sandy666
Replies
7
Views
141

### Re: VLOOKUP help (not SUMIF)

maybe use PivotTable

PersonValueProductPersonSum of ValueProductSum of Value

Person 1
500Product 1Person 1
1500Product 1
1000
11. ## Thread: Days and months into quarters

by sandy666
Replies
7
Views
185

### Re: Days and months into quarters

this is not vba and this is not a macro
if you've (PC) Excel 2010/2013 with PowerQuery add-in or 2016 and above you can try this M-code.
(Power Query == Get&Transform)
if not - it doesn't work

by sandy666
Replies
7
Views
110

no problem
13. ## Thread: Allocating revenue cash blows on a straight line basis over a fixed period

by sandy666
Replies
7
Views
110

### Re: Allocating revenue cash blows on a straight line basis over a fixed period

besides, I know what I wrote.
14. ## Thread: Allocating revenue cash blows on a straight line basis over a fixed period

by sandy666
Replies
7
Views
110

### Re: Allocating revenue cash blows on a straight line basis over a fixed period

or
post a link to the shared excel file with representative example of source and expected result using OneDrive, GoogleDrive, DropBox or any similar
15. ## Thread: Allocating revenue cash blows on a straight line basis over a fixed period

by sandy666
Replies
7
Views
110

### Re: Allocating revenue cash blows on a straight line basis over a fixed period

nothing attached
16. ## Thread: Days and months into quarters

by sandy666
Replies
7
Views
185

### Re: Days and months into quarters

you didn't show expected result so maybe this with PowerQuery

DATESQuarter

01/01/2019
1
17. ## Thread: How to group this in Pivot Tables

by sandy666
Replies
3
Views
90

### Re: How to group this in Pivot Tables

you are welcome

Have a nice day
18. ## Thread: Consolidating multiple rows into one single row - large data file

by sandy666
Replies
12
Views
235

### Re: Consolidating multiple rows into one single row - large data file

you are welcome

have a nice day
19. ## Thread: Consolidating multiple rows into one single row - large data file

by sandy666
Replies
12
Views
235

### Re: Consolidating multiple rows into one single row - large data file

there is no any export
there is Close&Load and you can choose where your query table will be placed or you can stay with query table as connection
what you mean by : exported code?
code, or rather...
20. ## Thread: How to group this in Pivot Tables

by sandy666
Replies
3
Views
90

### Re: How to group this in Pivot Tables

try with PowerQuery

// Table1
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
UnPivot = Table.UnpivotOtherColumns(Source, {"Customer Name"}, "Attribute", "Value"),
...
21. ## Thread: Consolidating multiple rows into one single row - large data file

by sandy666
Replies
12
Views
235

### Re: Consolidating multiple rows into one single row - large data file

How you get data into the sheet it's up to you

if you've data in the sheet just use Ctrl+T (check table name in Name Manager)
the rest you can do in PowerQuery Editor

22. ## Thread: Insert New Row in Excel Power Query

by sandy666
Replies
8
Views
651

### Re: Insert New Row in Excel Power Query

sure :laugh:

have a nice day
23. ## Thread: Consolidating multiple rows into one single row - large data file

by sandy666
Replies
12
Views
235

### Re: Consolidating multiple rows into one single row - large data file

is that what you want?

Source:

24. ## Thread: Insert New Row in Excel Power Query

by sandy666
Replies
8
Views
651

### Re: Insert New Row in Excel Power Query

aabbccdd

wweerrtt

with Table.FromRecords
25. ## Thread: Find 2nd and 3rd highest numbers in a row and return column header

by sandy666
Replies
10
Views
119

### Re: Find 2nd and 3rd highest numbers in a row and return column header

maybe something like this:

ETF-AETF-BETF-CETF-DMaxCustom

30
6
30
30
Results 1 to 25 of 150
Page 1 of 6 1