Help with Power Query to split multiple values in a cell split by comma to multiple rows

**chandramouliarun** · 10-05-2021, 04:49 AM

Hi All,

Hope you are doing well....I have a dataset with the combination of visitbillid and contextid denoting an encounter...Every encounter has diagnosis code ,charge codes and modifiers ...Now I have the input data as the diagnosis code seperated by commas , charge code seperated by commas and then the modifiers split by commas ..Now I require the output to have one code per row for diagnosis codes , charge code and modifiers ...Please find attached the sample excel worksheet with the input and the expected output ...Can you please help me here...

Thanks,
Arun

**AliGW** · 10-05-2021, 04:59 AM

There was a very similar query here - it may help: https://www.excelforum.com/excel-gen...owerquery.html

It uses this idea: https://prathy.com/2018/02/split-mul...ws-powerquery/

**rorya** · 10-05-2021, 05:31 AM

I'm sure there are simpler ways, but this should work - after converting your source data to a table:

Please Login or Register  to view this content.

Revised workbook attached.

**rorya** · 10-05-2021, 05:37 AM

Per the link in Ali's post, that can be shortened to:

Please Login or Register  to view this content.

**chandramouliarun** · 10-05-2021, 05:39 AM

Hi Rory, This works !..Really appreciate your help!

**AliGW** · 10-05-2021, 05:41 AM

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

**chandramouliarun** · 10-05-2021, 05:50 AM

Thanks Aligw!...Appreciate your help!

Help with Power Query to split multiple values in a cell split by comma to multiple rows

LinkBack

Thread Tools

Rate This Thread

Display

Help with Power Query to split multiple values in a cell split by comma to multiple rows

Re: Help with Power Query to split multiple values in a cell split by comma to multiple r

Re: Help with Power Query to split multiple values in a cell split by comma to multiple r

Re: Help with Power Query to split multiple values in a cell split by comma to multiple r

Re: Help with Power Query to split multiple values in a cell split by comma to multiple r

Re: Help with Power Query to split multiple values in a cell split by comma to multiple r

Re: Help with Power Query to split multiple values in a cell split by comma to multiple r

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Split One-Cell String of Data by Comma, into Multiple Cells

VBA: Split cell values into multiple rows and keep other data

[SOLVED] Multiple values in single cell (known column) split into rows with duplicate information

Macro to split Cells delimter comma to multiple Rows.

Split multiple values in a cell to multiple rows

Split cell data into multiple new rows and copy other column values

How 2 split multiple emails in one cell separated with a comma?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions