Data Transformation to create Comma Separated List in Power Query (Dynamically)

preview_player
Показать описание
We shall explore M Functions like Table.Group, List.Distinct, List.Sort in this Video.
  1. Bhavya Gupta
Рекомендации по теме
Data Transformation to 0:01:00

Data Transformation to create Comma Separated List in Power Query (Dynamically)

Data Transformation to 0:08:15

Data Transformation to create Comma Separated List automatically | FILTER, TEXTJOIN and CONCATENATEX

Split Comma Separated 0:04:18

Split Comma Separated Values or Delimited Data into Separate Rows

2 ways to 0:01:00

2 ways to Dynamically create Comma Separated List using Excel Formulas

Serializer in Data 0:10:27

Serializer in Data Transformation in Informatica - XML File to Comma Delimited Flatfile

How To Convert 0:00:41

How To Convert Data in Columns into Rows in Excel Document

Created a Comma 0:05:08

Created a Comma Separated Value List from a One Column Table or List

E-DAB 06: The 0:26:40

E-DAB 06: The Magic of Power Query to Import, Transform & Load Data

43. Angular 18 0:09:32

43. Angular 18 Custom Pipes Tutorial: Transform Your Data - #angular18

Get nth value 0:06:46

Get nth value from comma separated list in Power Query

MS Excel - 0:06:49

MS Excel - Text to Columns

Learn to Convert 0:12:05

Learn to Convert Pega Page List/ Value List to comma separated value (CSV) and vice versa #pega

(Stata13): How to 0:10:49

(Stata13): How to Reshape Wide to Longitudinal Data #reshapedata #reshapewide #reshapelong

How to convert 0:04:42

How to convert rows to comma separated values in Power BI | Real time scenarios in Power BI

Transpose Two Column 0:06:17

Transpose Two Column Table to Comma Separated Values

How to use 0:01:34

How to use TEXTJOIN formula to combine address data separated by comma in MS Excel 2016 Office 365

2D Motion Graphics 0:00:37

2D Motion Graphics | Inspiration Series

Opening .CSV Files 0:01:39

Opening .CSV Files with Excel - Quick Tip on Delimited Text Files

Data management: How 0:03:34

Data management: How to convert a string variable to a numeric variable

Java Transformation|| Comma 0:13:40

Java Transformation|| Comma Separate convert into multiple rows|| IICS Tutorial series- 18

How to Convert 0:03:17

How to Convert Comma-Separated Text Files to Excel Rows

Abstract Thesis 64: 0:09:50

Abstract Thesis 64: Power BI Power Query Create distinct sorted comma-separated text from a text

Combine Multiple Rows 0:09:15

Combine Multiple Rows into One Cell, Separated by Comma, Using Excel's Power Query

Power Bi - 0:06:15

Power Bi - Filter by Multiple Comma Separated Values

Комментарии
Автор

Wow, how did you come up with that solution?
Exactly what I was looking for ❤

piotrkuc
Автор

Thanks for the video, Do you know How could we do it other way around, I have comma seperated file and want to create a normalized table from it. Thankyou!!

SamaraSingh-tqjk
Автор

What can be done if there are multiple columns and it should compare only 2 column values? ex:- ABCDEF Output should be A (contains unique and different - output unique value) and F (different /same data - output comma seperated value) - BCDE remains same

priyankareddy
Автор

Sir I am unable to append data from multiple workbooks (fully-partial rows are capturing) through power query
workbooks are download in zip format and then extracted
But later if I save those excel workbooks manually it's working
Like this I have 72 workbooks
Do you have any trick to solve my problem

manideepak
Автор

Sir bse bhav copy excel sheet mei kaise download hoti hai, is par video bana do pls using VBA code, download file in temp folder then unzip then open excel bhav file then copy data and then then paste it in desired excel sheet .

MokshKiTaraf