Power Query TransformationsPower Query is part of Microsoft Excel. It’s a powerful tool that can help you with repetitive tasks. […] December 25, 2022 in Excel tagged power / transform / ETL / transformations. / data / query / Power Query Transform by Mike
Power Query Transform Phone NumberDo you need to split a column of imported Excel telephone number data into two columns so that […] October 16, 2022 in Excel tagged excel / text / import / query / power / transform / Power Query Transform by Mike
Text Transformation in Power QueryThis post covers a few common text transformations in Power Query. When you are working with a column, […] December 25, 2022 in Excel tagged split / delimiter / capitalization / upper / proper / text / case / merge / Power Query Transform by Mike
Split Column by DelimiterIn Power Query transformations, the split column by delimiter has something that you need to be aware of. […] December 25, 2022 in Excel tagged column / split / delimiter / Power Query Transform by Mike
Fill and Replace ValuesThere are times when you need to clean your dataset. Suppose you had a simple table of employees […] December 27, 2022 in Excel tagged replace / query / gaps / fill / power / values / Power Query Transform by Mike
Number TransformationsNumber transformations in Power Query are simple to do, but there is something you need to watch out […] December 28, 2022 in Excel tagged transform / query / number / Power Query Transform by Mike