If you have been using the MICROSOFT EXCEL software for some time, you must have heard or read about the word POWER QUERY.
POWER QUERY IS A DATA SHAPING TOOL WHERE WE CAN BRING THE DATA THROUGH A CONNECTION FROM VARIOUS SOURCES, DO SOME SHAPING SUCH AS REMOVING ROWS, COLUMNS, CHANGING DATA TYPES, TRIMMING THE DATA ETC. AND GET IT FINALLY FOR THE ANALYSIS IN OUR MAIN SOFTWARE SUCH AS MICROSOFT EXCEL OR MICROSOFT POWER BI .
Power Query tool, in fact, has immense powers to shape up the data in the way we want.
We’ll cover a lot of practical problems to sort them with the help of the POWER QUERY.
IN THIS ARTICLE, WE ‘LL LEARN TO CONCATENATE COLUMN DATA INTO A NEW COLUMN
We will take an example to understand the process of concatenating the columns to create a new column.
Let us take a table for the example which we will load from the EXCEL and transform it so that its loaded into POWER QUERY EDITOR.
The table for the example is shown in the picture below.
Read the article mentioned above.
In the navigator, use TRANSFORM DATA and the table would open in the POWER QUERY EDITOR.
FOLLOWING PICTURE SHOWS THE DATA FOR THE EXAMPLE.
We have the sales data for 7 week from the different continents.
We will concatenate the COLUMN1 with the custom text WAS GREAT. [ The text will become WEEK 1 WAS GREAT, WEEK 2 WAS GREAT…]
THE NOTIFICATION IN THE LOWER PORTION OF THE CUSTOM COLUMN DIALOG BOX SHOWS THE STATUS OF THE SYNTAX ERROR.
We don’t need to write the column names. Choose the column names from the available list on the right, select it and click INSERT button at the bottom. The name will appear in the FORMULA AREA.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE