How to Split Column Data into Rows in Power Query
In this video I will show you How you can Split the Column data into separate rows for easier to analyse as per your requirements in the data .
I have created videos on specific topics in Power Query. You can watch as per requirements.
Power Query Videos.
1 How to get Started with Power Query • How to get Started with Power Query
2 How does ETL works in Excel Power Query • How does ETL works in Excel Power Query
3 How to Import Data from Current WorkBook in Power Query Excel • How to Import Data from Current WorkBook i...
4 How to Import Text File Data into Excel Using Power Query • How to Import Text File Data into Excel Us...
5 How to Import CSV File Data into Excel Using Power Query • How to Import CSV File Data into Excel Usi...
6 How to Import Google Sheet Data in Excel • How to Import Google Sheet Data in Excel
7 How to combine multiple sheets in Excel using Power Query • How to combine multiple sheets in Excel us...
8 How to Import PDF Data into Excel Using Power Query • How to Import PDF Data into Excel Using Po...
9 How to Manage Columns in Power Query • How to Manage Columns in Power Query
10 How to use First Row As Header Power Query • How to use First Row As Header Power Query
11 How to use Fill Up Fill Down in Power Query • How to use Fill Up Fill Down in Power Query
12 How to UnPivot Columns _ Combine multiple columns _ Power Query • How to UnPivot Columns | Combine multiple ...
13 How to Sort Multiple Column in Power Query • How to Sort Multiple Column in Power Query
14 How to Split Columns in Power Query • How to Split Columns in Power Query
15 How to use Group By in Power Query • How to use Reduce Rows in Power Query
16 How to Filter Data in Power Query • How to Filter Data in Power Query
17 How to Merge Columns in Power Query • How to Merge Columns in Power Query
18 How to Add Index Number in Power Query • How to Add Index Number in Power Query
19 How to change Date format in Power Query from CSV File • How to change Date format in Power Query f...
20 How to create Duplicate Columns & Move Columns in Power Query • How to create Duplicate Columns & Move Col...
21 How to Identify Errors in Power Query • How to Identify Errors in Power Query
22 How to use Left Function in Power Query • How to use Left Function in Power Query
23 How to use Right Function in Power Query • How to use Right Function in Power Query
24 How to use Extract text and Transform Column in Power Query • How to use Extract Text in a new Column Po...
25 How to use Lower Upper Case Power Query • How to use Lower Upper Case Power Query
26 How to Add Prefix Suffix in Power Query • How to Add Prefix Suffix in Power Query
27 How to work with Dates in Power Query • How to work with Dates in Power Query
28 How to check Distinct and Unique Values in Power Query • How to check Distinct and Unique Values in...