Results 1 to 6 of 6

Power Query to Split a Column

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-08-2005
    MS-Off Ver
    Microsoft 365
    Posts
    839

    Power Query to Split a Column

    Hi,

    I have data in the attached workbook, arranged as a Table, and would like to use Power Query to split the data in column A into three columns with the person's name in one column, the date in the next and the region in the final column.

    I have achieved this in Power Query Editor by splitting the column by delimeters (using " / " as the delimiter).

    However, when I change the data type of the data in the date column from text to date, most of the dates are converted to "Error"

    Can someone please tell me what I'm doing wrong?

    Thanks!
    Attached Files Attached Files
    Last edited by andrewc; 07-27-2019 at 01:01 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Custom Permutations Column in Power Query from two columns in the same Query
    By PaintPaddy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-11-2019, 02:48 PM
  2. [SOLVED] Move From Column To Row - Power Query?
    By Gtrtim112 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 05-31-2019, 05:04 PM
  3. [SOLVED] Power Pivot does not load new column added in Power query
    By ibuhary in forum Excel General
    Replies: 12
    Last Post: 02-19-2019, 03:53 AM
  4. Sub-Forum for Excel Power Tools (Power Query, Power Pivot & Power BI)
    By chullan88 in forum Suggestions for Improvement
    Replies: 10
    Last Post: 06-28-2018, 02:25 PM
  5. Adding Column in Power Query
    By fuerte in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-28-2018, 12:39 PM
  6. Adding Column in Power Query
    By fuerte in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-28-2018, 11:15 AM
  7. Power Query - add column with Table name
    By zico8 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-11-2017, 12:58 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1