Converting Text Column having Text and Scientific Notation

Hi Las 

In Power Query, data in a column should be changed to the same data type.

Currently this column is Text type. If you don't want to do any calculation or aggregation on this column, you can remain it as Text type. However, if you want to do some calculation, you can extract necessary data into a new column and change it to a specific data type. 

You can also use features like Pivot/Unpivot/Transpose... to change the table structure. We don't know the meaning of these text strings and what you want to do later, so we cannot suggest more on how to handle it. But ensure that the table should be a flat tabular structure and every column is expected to have data of the same single meaning.

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.