Search:

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

Page 1 of 6 1

1. Thread: Can someone help me with this? Probably a beginner level formula.

by sandy666
Replies
8
Views
102

Re: Can someone help me with this? Probably a beginner level formula.

did you try a PivotTable?

by sandy666
Replies
6
Views
109

Re: Match Function Problem

sure

What is PowerQuery?

by sandy666
Replies
6
Views
109

Re: Match Function Problem

IMHO PowerQuery (Get&Trannsform) would help
4. Thread: Combining 2 lists (for each cell in first list assign all cells in second list)

by sandy666
Replies
6
Views
167

Re: Combining 2 lists (for each cell in first list assign all cells in second list)

you are welcome

have a nice day
5. Thread: Combining 2 lists (for each cell in first list assign all cells in second list)

by sandy666
Replies
6
Views
167

Re: Combining 2 lists (for each cell in first list assign all cells in second list)

or with PowerQuery aka Get&Transform

table1table2table1table2

austinappleaustinapple

justinbananaaustinbanana

paulorangeaustinorange
6. Thread: Power Query column alignment

by sandy666
Replies
18
Views
584

Re: Power Query column alignment

you can try this

let
Source =...
7. Thread: Power Query column alignment

by sandy666
Replies
18
Views
584

Re: Power Query column alignment

it takes some time with ca. 5 GB of data (sorry, I didn't check unzipped file size :))
8. Thread: Power Query column alignment

by sandy666
Replies
18
Views
584

Re: Power Query column alignment

https://i.postimg.cc/g2gzkLK5/screenshot-106.png

your previous source is incorrect because there is no company number, address lin1, etc... , I am trying with...
9. Thread: Power Query column alignment

by sandy666
Replies
18
Views
584

Re: Power Query column alignment

this is 868 MB not 5 GB :)

use header names what you want split/concatenate

and don't quote whole post, please!
10. Thread: Power Query column alignment

by sandy666
Replies
18
Views
584

Re: Power Query column alignment

is that what you want?

first ten rows...

...
11. Thread: Power Query column alignment

by sandy666
Replies
18
Views
584

Re: Power Query column alignment

I'll wait to see if the post#4 will work ;)
12. Thread: Power Query column alignment

by sandy666
Replies
18
Views
584

Re: Power Query column alignment

you forgot about one thing: DataSource.Error: Could not find a part of the path 'C:\Users\Ben\Desktop\PQ\persons-with-significant-control-snapshot-2019-09-13.csv'.
13. Thread: how to divide and unique names in to one slicer

by sandy666
Replies
11
Views
174

Re: how to divide and unique names in to one slicer

I don't know
Get it or forget it ;)
14. Thread: how to divide and unique names in to one slicer

by sandy666
Replies
11
Views
174

Re: how to divide and unique names in to one slicer

use PowerQuery
split first column by delimiter ", " (comma space) to rows

then you can:
create PivotTable from Query Table and insert slicer
or
load Query Table to the sheet and insert slicer...
15. Thread: how to divide and unique names in to one slicer

by sandy666
Replies
11
Views
174

Re: how to divide and unique names in to one slicer

something like this?

https://i.postimg.cc/5N35wTCD/slicer.jpg
16. Thread: how to stop auto show query table at refreshing

by sandy666
Replies
17
Views
207

Re: how to stop auto show query table at refreshing

see post#16

but I can't help with vba or formula
17. Thread: Getting Power Query to add new values to the bottom

by sandy666
Replies
3
Views
291

Re: Getting Power Query to add new values to the bottom

to the merged table add custom column with mentioned function. it will give you date and time. sort ascending. remove this column.
now you can add new data into your source table(s) and after...
18. Thread: how to stop auto show query table at refreshing

by sandy666
Replies
17
Views
207

Re: how to stop auto show query table at refreshing

maybe look at: https://contexturesblog.com/archives/2016/08/18/quick-ways-unpivot-excel-data/
19. Thread: how to stop auto show query table at refreshing

by sandy666
Replies
17
Views
207

Re: how to stop auto show query table at refreshing

the question is too general

what does that mean: combine multiple columns?
what you want to achieve before PivotTable?
20. Thread: how to stop auto show query table at refreshing

by sandy666
Replies
17
Views
207

Re: how to stop auto show query table at refreshing

you are welcome

have a nice day
21. Thread: how to stop auto show query table at refreshing

by sandy666
Replies
17
Views
207

Re: how to stop auto show query table at refreshing

as I said before
- Connection only
then
- Insert
- Pivot Table
- Use an external data source
- Choose connection
- Open
22. Thread: how to stop auto show query table at refreshing

by sandy666
Replies
17
Views
207

Re: how to stop auto show query table at refreshing

try this

https://1drv.ms/x/s!AopTvf3RGAN5kzb3xscazGFmOWFS?e=xsGntt
23. Thread: how to stop auto show query table at refreshing

by sandy666
Replies
17
Views
207

Re: how to stop auto show query table at refreshing

I said SHARE file and post a link to SHARED file

btw. do you want hide Query Table or hide columns in Query Table?

if hide Query...
24. Thread: how to stop auto show query table at refreshing

by sandy666
Replies
17
Views
207

Re: how to stop auto show query table at refreshing

what is you excel version?

edit:
post representative example of source data and expected result - share excel file on Onedrive, GoogleDrive or any similar then post link here
25. Thread: how to stop auto show query table at refreshing

by sandy666
Replies
17
Views
207

Re: how to stop auto show query table at refreshing

remove these columns from Query Table
Results 1 to 25 of 150
Page 1 of 6 1