Forum

How to group the te...
 
Notifications
Clear all

How to group the text or Numbers

3 Posts
2 Users
0 Reactions
105 Views
(@siva97237)
Posts: 2
New Member
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
Alan Sidman
(@alansidman)
Posts: 223
Member Moderator
 

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
(@siva97237)
Posts: 2
New Member
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
Share: