# Search:

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

Page 1 of 6 1

1. ## Thread: Convert a list into rows

by sandy666
Replies
5
Views
67

### Re: Convert a list into rows

with PowerQuery (Get&Transform)

Company ACompany AThe High StreetBig TownAA1 3AA

The High StreetCompany BThe MewsMain RoadLittle TownAA5 5AA...
2. ## Thread: UN-pivoting a pivoted range

by sandy666
Replies
13
Views
165

### Re: UN-pivoting a pivoted range

You are welcome

Have a nice day

note:
Example with the last M-code
3. ## Thread: UN-pivoting a pivoted range

by sandy666
Replies
13
Views
165

### Re: UN-pivoting a pivoted range

ok, try this:

// Table1
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
Group = Table.Group(Source, {"Name From"}, {{"Count", each _, type table}}),
List1 =...
4. ## Thread: UN-pivoting a pivoted range

by sandy666
Replies
13
Views
165

### Re: UN-pivoting a pivoted range

post example excel file with real structure of data
5. ## Thread: UN-pivoting a pivoted range

by sandy666
Replies
13
Views
165

### Re: UN-pivoting a pivoted range

MARK858

Thanks

capson

could you answer for post #4 ?

PowerQuery (Get&Tranaform) Excel 2010 and higher
6. ## Thread: UN-pivoting a pivoted range

by sandy666
Replies
13
Views
165

### Re: UN-pivoting a pivoted range

maybe

Name FromName ToTypeName FromName To.1Type.1Name To.2Type.2Name To.3Type.3Name To.4Type.4Name To.5Type.5

Alisa MoralesElwood Iglesiasvalue twoAlisa MoralesElwood Iglesiasvalue two
...
7. ## Thread: Excel formula to rearrange the cell contents ENG/DEF/001/14 to ENG/DEF/14/001

by sandy666
Replies
10
Views
135

### Re: Excel formula to rearrange the cell contents ENG/DEF/001/14 to ENG/DEF/14/001

but which one?
8. ## Thread: Golf majors; retreive data from Wikipedia articles

by sandy666
Replies
10
Views
238

### Re: Golf majors; retreive data from Wikipedia articles

I don't know Golf, I know Data :)
so I don't know what you want to achieve
but you've start position - the rest is transforming only
9. ## Thread: Excel formula to rearrange the cell contents ENG/DEF/001/14 to ENG/DEF/14/001

by sandy666
Replies
10
Views
135

### Re: Excel formula to rearrange the cell contents ENG/DEF/001/14 to ENG/DEF/14/001

with PowerQuery (Get&Transform)

rawresult

ENG/DEF/001/14ENG/DEF/14/001

// Table1
10. ## Thread: Calculating mumber of incidents per month

by sandy666
Replies
12
Views
174

### Re: Calculating mumber of incidents per month

this is PowerQuery (Get&Transform) for Excel 2010 and higher

you need create table (Ctrl+T) as you see Blue table, then load it to PQ Editor and adapt M-code to your needs and next load result...
11. ## Thread: Transpose and group? How do i transpose one column into multiple rows base on value in another column

by sandy666
Replies
4
Views
126

### Re: Transpose and group? How do i transpose one column into multiple rows base on value in another column

You are welcome
12. ## Thread: Calculating mumber of incidents per month

by sandy666
Replies
12
Views
174

### Re: Calculating mumber of incidents per month

or

Column1Column2Column3Column4Column5Column6Column7Column8Column9Column10Column11Column2Count

Farnborough
03/01/2019Slip. Trip from HeightEmployeeMinorAberdeen
0Incl HO
49January
12
13. ## Thread: Transpose and group? How do i transpose one column into multiple rows base on value in another column

by sandy666
Replies
4
Views
126

### Re: Transpose and group? How do i transpose one column into multiple rows base on value in another column

try

// Table1
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
Group = Table.Group(Source, {"Column1"}, {{"Count", each _, type table}}),
List =...
14. ## Thread: Golf majors; retreive data from Wikipedia articles

by sandy666
Replies
10
Views
238

### Re: Golf majors; retreive data from Wikipedia articles

and end result :)

1988DatesJune 16–20, 1988

1988LocationBrookline, Massachusetts

1988Course(s)The Country Club
Composite Course
15. ## Thread: How to convert date to Month/Year only

by sandy666
Replies
5
Views
73

### Re: How to convert date to Month/Year only

probably your dates are as text
try text to columns then set custom format : mm-yyyy

by sandy666
Replies
2
Views
41

or

A
B
C
D
E

1
17. ## Thread: Golf majors; retreive data from Wikipedia articles

by sandy666
Replies
10
Views
238

### Re: Golf majors; retreive data from Wikipedia articles

in single table for all years
here is just breakthrough between 1986 and 1987

1987Tournament informationTournament information

1987DatesJune 18–21, 1987

1987LocationSan Francisco,...
18. ## Thread: how to create stacked bar for schedule/utilization

by sandy666
Replies
2
Views
30

### Re: how to create stacked bar for schedule/utilization

ignore post#2
19. ## Thread: how to create stacked bar for schedule/utilization

by sandy666
Replies
2
Views
30

### Re: how to create stacked bar for schedule/utilization

something like this?

IDStart timeExam DurationIDDurationTot

1
11:20
01:18
1
20. ## Thread: Golf majors; retreive data from Wikipedia articles

by sandy666
Replies
10
Views
238

### Re: Golf majors; retreive data from Wikipedia articles

After posting I realized structure of the tables are different but as I can see you almost solved the problem
You didn't say what you are tryin' to achieve so M-code is simply for each single year...
21. ## Thread: Golf majors; retreive data from Wikipedia articles

by sandy666
Replies
10
Views
238

### Re: Golf majors; retreive data from Wikipedia articles

structure of the tables before 1987 is different than >=1987

SelectTitleLabelDetail

1897Tournament informationDatesSeptember 17, 1897

1897Tournament informationLocationWheaton, Illinois
22. ## Thread: Golf majors; retreive data from Wikipedia articles

by sandy666
Replies
10
Views
238

### Re: Golf majors; retreive data from Wikipedia articles

maybe something like this:

// Select
let
Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
#"Invoked Custom Function" = Table.AddColumn(Source, "fnUSOpen", each...
23. ## Thread: Golf majors; retreive data from Wikipedia articles

by sandy666
Replies
10
Views
238

### Re: Golf majors; retreive data from Wikipedia articles

maybe from here: https://en.wikipedia.org/wiki/U.S._Open_(golf)
24. ## Thread: Average ifs for filtered data (visible data)

by sandy666
Replies
4
Views
110

### Re: Average ifs for filtered data (visible data)

you can post a link to shared excel file with source data and expected result. use OneDrive, GoogleDrive or any similar.
25. ## Thread: TEXT IN A PIVOT TABLE's VALUE FIELD

by sandy666
Replies
9
Views
248

### Re: TEXT IN A PIVOT TABLE's VALUE FIELD

You can't because in Values Area your code will be counted
Try to put NAME and CODE into Rows Area, choose Report Layout in Tabular Form

https://i.postimg.cc/dtfKP454/screenshot-78.png
Results 1 to 25 of 150
Page 1 of 6 1