Power Querry value stored as Table

[Syndicate_Admin]

Hello,

I'm really struggling with one column. I imported data through the API, and some rows have the value visible, while others can be seen as a Table. I know that the correct value is present in the Table. Is there simple way to go over it and make both values visible in new added column?

Thank You

[Syndicate_Admin]

I found my mistake and now its worked. Thank you very much!!

[Syndicate_Admin]

Yes, i m not using coding very often. I changed as you writed and now I have new error with Column name:

[Syndicate_Admin]

Thanky you for your answer. Seems that it may work, but there is error when record wasnt found. There are some null values too. Need to add something more?

[AlienSx]

I don't see how you may get an error with this code other than you don't know how to correctly incorporate it into yours. Replace data_column_name with SHVc.rows.row.SerialNr. Replace Source with the name of your last step. 

[AlienSx · Accepted solution]

Hello, @Ints. If table consists of single row and column the try this: 

Table.AddColumn(
   Source, "new_column_name", 
   (x) => try Table.FirstValue(x[data_column_name]) otherwise x[data_column_name]
)