Notifications
Clear all
Power Query
3
Posts
2
Users
0
Reactions
505
Views
Topic starter
I have data like below
| DATA TABL | |
| TEXT | TYPE |
| DMK01 | Area01 |
| DMK02 | Area01 |
| DMK03 | Area01 |
| DMK04 | Area01 |
| DMK05 | Area01 |
| DMK06 | Area01 |
| DMK10 | Area01 |
| DMK11 | Area02 |
My desired result is like below
| TYPE | FROM TO RANGE (Desired Result) |
| Area01 | DMK01-DMK06,DMK10 |
| Area02 | DMK11 |
how can i achieve it with power query
please help
Regards
Samba
Posted : 20/10/2021 6:39 am
Will this presentation work for you. I did this in Power Pivot and the link to show you how I did this follows.
https://sfmagazine.com/post-entry/july-2018-excel-reporting-text-in-a-pivot-table/
Posted : 20/10/2021 12:32 pm
Topic starter
Thanks for your reply,
but my desired result would be like "DMK01-06, DMK10"
not like "DMK01, DMK02, DMK03, DMK04, DMK05, DMK06, DMK10" as 01 to 06 are serially available
Posted : 23/10/2021 7:52 am