Extract a column of data from a Power Query table

After grouping data in Power Query, in this example, the data is exactly how we want it. It's grouped into the right rows in the column.

BUT! It's in a collapsed column of tables. If we expand, the data will fly apart. So, how do we get a column of data out of a table and keep the data in the appropriate rows and cells?

We have to use the Power Query function: Text.Column

In this video you'll see
- Camera Tool
- using a line-feed as a delimiter
- how Table.Column is used
- Grouping in Power Query
- Extract values from a list

For an intro to Get & Transform (Power Query) try my Lynda/LinkedIn course:

My book: Guerrilla Data Analysis 2nd Edition

[CeliaAlvesSolveExcel]

Love it, Oz!
by using the special character as delimiter; and you can skip the table column step.

[SimX]

Camera tool? This is life changing stuff!

[lknchad]

for a newbie to power query, i had to burn the midnight oil until i stumbled upon your video. I will tell my mom that you let me have sweet dreams.

[bassiegames]

FINALLY!!! thank you ! this was just what i needed.

[makaveli]

Well you just solved my problem! I like the way you explain. This is neat!

[sasavienne]

Excellent as usual... Thanks a lot. 👍 🌟 🌟

[cortinas]

I like all your videos, you got a great way to teach! Regards!

[wayneedmondson]

Thanks Oz.. another great tip.. concat w/line feed and then word wrap.. excellent. Thumbs up!

[excelaficionado]

Amazing way to teach, really liked it !!!

[entertainmentgalaxy]

Thanks OZ. That is massive. Mama would b so proud with this trick :). Thanks for M code fun.

[garethwoodall]

You are amazing brah. So many ideas from this.

[ExceliAdam]

In this kind of situations I prefer to change Grouped Rows step. So instead
{{"Count", each _, type table}}
I write

{{"Count", each [Name], type list}}
and then I can immediately Extract values.

[lmk]

Awesome Trick. That's been a huge problem. Mom is going to jump for joy! :-)

[ExcelExciting]

Thundering with fire 🔥 just love that..

[SamehRSameh]

Can i extract more than one column by table.column() function ?

[wesszep]

Magical, too good, when you do it seem so natural !😜

[deninsrmic]

Amazing Oz, thank you for sharing it with us. Working Power Query Editor is always interesting. By the way, is there a good book on M-language you would recommend? 👍

[MuhammadAhmed-wkzh]

Please provide excel file of source data. THanks

[erictsang]

can you enlighten me how to combine two sheets with different columns in to one sheet with power query?
you have any movie clip for this issue ?
Thanks in advance

[DougHExcel]

lightning., ..bam...! PQ goodness...bam! Excel--lent!