Forum Discussion
'Table' and 'List' showing in Power Query columns that should be peoples names or a business unit
Hi -
Not sure why your data ended up this way, but these are called "structured columns" i.e. each entry in the column contains a "structure", in this case a table or a list.
Here is a good article about how to "expand" these columns:
Basically, just click on the little icon at the top of the column and pick the values you want to extract. Because your table only contains one row it should not add additional rows to your overall table.
Hope this helps,
Peter.
Resolver IIHi -
Not sure why your data ended up this way, but these are called "structured columns" i.e. each entry in the column contains a "structure", in this case a table or a list.
Here is a good article about how to "expand" these columns:
Basically, just click on the little icon at the top of the column and pick the values you want to extract. Because your table only contains one row it should not add additional rows to your overall table.
Hope this helps,
Peter.
hi, i am having this same issue! except when i "Expand" it creates multiple rows to my table, any suggestions on how to fix?
Hi gg082295 - In the column header to the righ tof the column label I assume you have a double opposing arrow icon? Right click on that and select Expand with Values (if I recall correctly). Select the value you want to use, eg name, and apply. Let me know how that goes.