Get nth value from comma separated list in Power Query

Показать описание

This video shows how to retrieve a value from a comma seperated list. The long method requires splitting a value into multiple columns and then makin a selection. This method selects the nth value directly.

Master Functions and Syntax in M

ABOUT BI Gorilla:
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.

SUPPORT MY CHANNEL

SUBSCRIBE TO MY CHANNEL

LET'S CONNECT:

Thank you for your support!

#PowerBI #PowerQuery #BIGorilla

Рекомендации по теме

Комментарии

Exactly what I was trying to figure out a couple of days ago. Thank you so much!

aliramadan

Thank you so much! This was sooo helpful!!!!

phylisciaboulommavong

Wow dat's so amazing, What if I wanted to show several values in a different arrange?

Greg.Contreras

excellent video. What if i wanted to keep in the cell only where the text is equal to a certain criteria ex. CO-Test, CO-Test2, Software, Laptop. In this scenario I only want to keep the Items that have CO-. So the results would be CO-Test, CO-Test2?

jayeshaw

Hi Rick, can you shed a light for me on those sample data: each row 12345678-AH-AH-CY9 or 12345678-2-AB-AC-CY9, how can i extract 12345678 and 12345678-2 in to separate column. Thank you so much.

BusyNee

Great, thank you hopefully it will help me with messy data. Having sporadic values with commas as decimal separator inside a csv using comma as delimiter drives me nuts🤯. I dont know why excel is able to open the text files individually without failure by double clicking them, but in Power query every row with those value gets his column shifted. Get them in as text is my last hope at the moment.

sngularityxd

How do you split the "List"? I need a new row with all the values of the list in separated cells.

vico

I have the problem where I have a column that has comma separated values in it, but the structure is not always the same for each line. meaning that sometimes the value I want is found in the comma delimiter Nr. 3 and sometimes it is in Nr. 4. The name of the delimited value however is always the same. So is there a way to first search for a particular text and then just extract the value that follows after that text ?

marcbaier

Hello everyone, how to get first three values from a column? It would be time saver for me! Thanks

latoriabaggs

Get nth value from comma separated list in Power Query

Get nth value from comma separated list in Power Query

How to find the nth occurrence of a text in Excel - Office 365

How to extract text after the second or nth specific character space or comma

Find the Nth Matching Value

Excel Lookup and Find the 2nd, 3rd, 4th or Nth Occurrence / Match (Without Using an Array Formula)

Lookup & Find 1st, 2nd, Nth Matching Value in Excel & Google Sheets

How to use vlookup to find the 2nd, 3rd or Nth match in excel

SQL Query to find Nth highest salary in Oracle using ROW_NUMBER function?

Pointwise Convergence | Series of Functions

Use VLOOKUP to Find the 2nd Match (or nth Match)

#Shorts | VLOOKUP to find the nth Order Occurrence

Extract Text From Nth Occurrence of a Space in a Cell

Split Comma Separated Values or Delimited Data into Separate Rows

Excel formula to find the nth Smallest value

Find the Nth. Highest Value in a List dynamically in Excel

Find 1st, 2nd, Nth Highest Matching Value in Excel & Google Sheets and Return Another Cell

How to Easily Find the nth Largest or Smallest Values in an Array in Excel

VBA to find nth Occurence of a Text in Excel - Advanced Excel VBA example

Lookup and Find the 2nd, 3rd, or the Nth Matching Value in Excel using NVLOOKUP function

VLOOKUP All Matches with this Crazy Simple Trick

Excel Magic Trick 1373: Formula to Extract Every Nth Value & Conditionally Format Every Nth Valu...

Counting the Nth Occurrence of a Value in Excel

Excel Magic Trick 1003: Lookup nth Duplicate When Column With Lookup Value Is Sorted

Find nth Largest Number in Excel