transform

So I have a workbook that has 5 worksheets I want to use, but those sheets are huge and have data going back many years. This makes the queries, reports and dashboards in PowerBI cumbersome. Q1: Is there a way to get PowerBI to only import the last two years from a certain date? I say...

My form on SharePoint has a multiple-choice field. When I bring that data into Excel (as a connection), it displays with extra characters like this: When there's more than one name, I want "/" to replace those characters. When it's just one name, I want the characters removed like this: I'm...

Hi everyone! I have a spreadsheet to convert the (attached picture) in green to rows in yellow. Is there possible formula or code to create the remining data from rows 7 thru 24 to columns L thru V) ? Here is steps example for manual input (to convert green row 2 into yellow rows 2, 3 and 4)...

Hello, I have two strings of letters (columns String A and String B) and I want to transform them into strings like the ones in Solution 1 and Solution 2 correspondingly. String A String B Solution A Solution B 7-6-1-3-4-2-2 DDDDDTT 7-6-1-3-4-2 DDDDDT 3-3-0-2-0-0 DDTDTT...

Hi, I have a huge data which is converted from another source to excel required to be set in Tabular format with help power query.Headers are already available it should be same as it is, Blank columns and rows to be remove, Data in column which does not have any headers to be create a new...

Hey I need some help transforming an export I have so I can upload it. I would like to turn 1 line into blocks of 4 as per below, can anyone help please?

Hi MrExcel Community, I am facing a new unstacking data challenge. ? Context I have a bunch of Property Names, two Attributes which are stacked together in the following order: (1) a date (in a text format) and (2) a percentage change and their Values. Target Here is that table format I am...

Hello, do some one know how to transform Dates? I have a column with the ends of all Months per year: End of the month date 31.01.2019 28.02.2019 30.03.2019 etc... Question: How can I transform this column. I want that all of this dates only the days are changing to 14. this: 14.01.2019...

Hi there, I was wondering how can I use a parameter in a query using the "Get & Transform" . For simplification purposes, I have a saved query called 'dbQuery': select * from Balances where Balances.CoprID=[Idpara] IdPara is the parameter. "Get & transform" doesn't recognize this query because...

Hello, I Have a query that combines 6 connection only data sets, removes a bunch of columns, moves them around, changes all "Dates" to date code, etc. Nothing out of the ordinary. In the resulting table/tab "Combined data", I add a number of other columns with formulas that grab/change some of...

Hi, I'm doing my first baby steps in power query. I tried to create query from excel workbook through the 'Get and and transform' and it took ages, but when I tried to do the same through the "Data model' UI it took just seconds... Why is that? What is the difference between the two methods...

I have multiple workbooks with each one filtered to show different data. I now need to combine them but when I use get and transform, the tables are ignoring the filters and showing the data without any filters applied. What am I doing wrong? Thank you Figen

Hi there, I have been using the get and transform function in excel for a while. I have a workbook with a lot of individual reports. I have connected them using get and transform, but when I replaced the data with current month's data, for some reason my merged table that is connected to all...

Hi, have anybody experienced where their Excel version's Get & Transform is unresponsive? I have created a file and done some queries etc just to have it crash and now it does not even recognise that I had a query. Thank you.

Hi, Is there a way that I can make the last line of this Power Query statement dynamic? i.e. always expand all columns? let // Get path Pathparameter = Excel.CurrentWorkbook(){[Name="sys_im_parameters"]}[Content], Pathparameter_value = Pathparameter{0}[Column1], //main query...

Hello everybody. I've a value in a cell in hour format: 00:05:37 I need to transform it in seconds: 337 How can I manage the matter? Thank's.

Hi all, I need to transform/ re-arrange data in Access. Below table illustrates the data that I currently have: <tbody> Year FY18 FY18 FY18 FY18 Month MAR MAR FEB FEB Country Channel Brand Item Number SLS UNT SLS CST SLS UNT SLS CST China RLS MSW 10004 34 $87.00 56 $80.00...

Taking my first steps in VBA and Get & Transform Data functionalities in Excel 2016. I have 2 Excel workbooks (different files) - a transport note (template.xlsm) and the second one for the entire log or history (log.xlsx). I need the rows from the transport note to be copied into the workbook...

This might be a stupid question, but how do I update my Excel 2016 so that it has the new "Get & Transform Data" Data ribbon tab instead of the old "Get External data" tab?

Hello All, How can I create a new blank query.. I am using Office 2010 rather than office 2016 (Get and Transform). Thanks.