transform

Hi, I'm trying to transform date string formatted like: Jan 1, 2017 6:01:12 AM PST How do I transform those dates with a formula into a actual date as recognised by excel?

Hi, I'm trying to import a csv file with dates formatted like: Jan 1, 2017 6:01:12 AM PST How do I transform those dates when importing in PowerBI (and powerpivot)?

Hi all It seems that since a recent upgrade of Power Query (Excel 2013), whenever I expand a table from an Excel data source, Power Query introduces a new Folder named "Transform Binary From..." which contains a subfolder named "Sample Query" and 2 other items. The Subfolder also contains 2...

hello, I want to transform the first table to the second: ¿can you help/guide me? <colgroup><col span="3"><col span="2"></colgroup><tbody> Segment Channel Product.ID jan feb Domestic 1 23 5 1 Domestic 1 54 1 5 Online 2 43 34 5 Segment Channel Product.ID Month...

<colgroup><col><col></colgroup><tbody> I have imported a txt file in to Query editor, separated in to two columns and cleansed the data to give me a data set with 31 unique row labels in column A and the information in column B. (see below) Is there a way I can transform this data within query...

Hi All, I have a massive table of data that I am trying to rearrange in the most time-efficient manner possible. From column D to II I have data from row 2 to 375, with each three columns (i.e. D, E and F) being related. I would like to rearange all this data into three columns (A to C) by...

Hi, I have to transform a table with multiple repeatable rows into columns. Tried do use the Offset function but did not work. I am using Excel 2010. My raw data looks like this <TBODY> Application</SPAN> Attribute 1</SPAN> Value 1</SPAN> Attribute 2</SPAN> Value 2</SPAN> Attribute...

Hi Guys, Im trying to change every single number in an excel file to a positive number, no matter if its negative or positive, every single number should be shown as positive, is there any quick form to do this without needing to click every cell manually and writting the amount without a -...

I have a spreadsheet that lists the following information in rows: Name ID Begin Date End Date Hours per Day Joe Smith 10001 3/18/2013 3/22/2018 8 Jane Smith 11001 8/26/2013 9/19/2013 4 There are a lot more rows, but that represents the 5 columns of data. I need to transform the data in such...

Hi All, I have a table of quantity of hearing instruments sold by date that I would like to transform into a list (3 columns): item; date; qty As a total I have: 1. 114 different dates in columns 2. 760 different items in rows Please have a look at the data below PS:I get the xls files in...

Hi All I have a table for collecting results for different KPI's. When it comes to consolidating / aggregating the table into summaries, some KPI's should be summed (e.g. volume of corporate cards) and some KPI's should be averaged (e.g. average spend on corporate card). Therefore I have a...