Power query, split column

V

Vaja

New Member
Joined
Mar 18, 2022
Messages
13
Office Version
  1. 2016
Platform
  1. Windows
In my power query sheet from the Split column --in Advanced option is not shown with column and row option.
As I highlighted in the image so, please solve this problem.


Screenshot 2022-06-25 110535.jpg
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
Sort by date Sort by votes
Could be down to your version as there was an upgrade was done in June 2017
  • New transformation features:
    • Add Column by Example.
    • Split Column (by Delimiter/Number of Characters) into rows.
    • Basic mode for Group By operation.
    • Extract Text Before/After/Between Delimiters.
    • Unpivot Only Selected Columns.
  • Combine Files experience—ability to reference first file as example.
  • New Go to Column in Query Editor.
  • SAP HANA Connector—enhancements to Parameter Input UX.
www.microsoft.com

June 2017 updates for Get & Transform in Excel 2016 and the Power Query add-in - Microsoft 365 Blog

Today, we released eight data transformation and connectivity updates for Get & Transform—a powerful set of Excel 2016 features based on the Power Query technology, which provides fast, easy data gathering and shaping capabilities.
www.microsoft.com www.microsoft.com
 
Upvote 0
Solution
You must log in or register to reply here.

Similar threads

C
  • Locked
  • Question Question
Refresh Errors in Power BI Desktop loading queries
Replies
1
Views
108
Fluff
Fluff
C
  • Solved
Refresh errors after normalizing flat files coming from a folder in Power BI
Replies
3
Views
141
chriscorpion786
C
C
  • Solved
Help me Convert, Merge and Transpose a pdf table into a singular row, and then repeat that step ad nauseam to create a database
Replies
5
Views
566
Clonk92
C
B
  • Solved
Split text by three characters before delimiter into rows
Replies
2
Views
182
brawnystaff
B
R
  • Question Question
Power Query Help to Calculate Stock Splits
Replies
0
Views
157
rasinc
R

Forum statistics

Threads
1,223,649
Messages
6,173,580
Members
452,521
Latest member
bdough27

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top