Retain column type after expanding table

Hi all,

I added a new column which is a table in power query and when I expand the table, the previous data types were all changed. How can I ensure the data types stays the same after expanding the table? Do in need to use Table.TransformColumns?

Before adding column:

After adding column

Thank you for your help.

Hi @ysherriff,

See if this works for you

Or explore Value.ReplaceType as illustrated here


Like always Melissa. You are a gem.

Much appreciated.