# Search:

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

Page 1 of 6 1

1. ## Thread: how to extract only character's ???

by sandy666
Replies
6
Views
131

### Re: how to extract only character's ???

with PowerQuery aka Get&Transform

RawText

A1B2C3D4E5F6G7H8J9K0ABCDEFGHJK

zxc34nbv55qwertyzxcnbvqwerty

AaBb12345CcDdEe678UuRr900AaBbCcDdEeUuRr
2. ## Thread: power query running total help

by sandy666
Replies
3
Views
159

### Re: power query running total help

or try

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

by sandy666
Replies
3
Views
159

### Re: power query running total help

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

by sandy666
Replies
6
Views
72

### Re: populate cells using

maybe something like this with PivotTable

Count of CourseCourse

StudentIDEnglishFrenchMathScience

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

by sandy666
Replies
6
Views
86

### 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 =...
6. ## Thread: New Group of Rows to a Table

by sandy666
Replies
6
Views
86

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

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

by sandy666
Replies
6
Views
86

### 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
46

### Re: Countifs formula

sure

have a nice day

by sandy666
Replies
3
Views
46

### Re: Countifs formula

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

by sandy666
Replies
1
Views
71

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

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

by sandy666
Replies
7
Views
145

### Re: VLOOKUP help (not SUMIF)

maybe use PivotTable

PersonValueProductPersonSum of ValueProductSum of Value

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

by sandy666
Replies
7
Views
186

### 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
116

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

by sandy666
Replies
7
Views
116

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

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

by sandy666
Replies
7
Views
116

### 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
16. ## Thread: Allocating revenue cash blows on a straight line basis over a fixed period

by sandy666
Replies
7
Views
116

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

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

by sandy666
Replies
7
Views
186

### Re: Days and months into quarters

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

DATESQuarter

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

by sandy666
Replies
3
Views
93

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

you are welcome

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

by sandy666
Replies
12
Views
238

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

you are welcome

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

by sandy666
Replies
12
Views
238

### 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...
21. ## Thread: How to group this in Pivot Tables

by sandy666
Replies
3
Views
93

### 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"),
...
22. ## Thread: Consolidating multiple rows into one single row - large data file

by sandy666
Replies
12
Views
238

### 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

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

by sandy666
Replies
8
Views
660

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

sure :laugh:

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

by sandy666
Replies
12
Views
238

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

is that what you want?

Source:

by sandy666
Replies
8
Views
660