+ Reply to Thread
Results 1 to 1 of 1

Power Query, after expanding column there are Values as well as Tables

  1. #1
    Registered User
    Join Date
    02-20-2023
    Location
    Baykonur
    MS-Off Ver
    Office 1-2-3
    Posts
    4

    Question Power Query, after expanding column there are Values as well as Tables

    Hi Folks,

    after expanding one column there were Values, I have changed them to text. After that I needed to work with this column with some conditions formulas. Then I have realized, that there are in some rows Errors, because its nested Table in the field where are Values.
    I have tried to extract those to new column and expand those Error rows again, but it doesnt work.
    Can you please give me som advice how to handle with this mixed column?
    In the nested table are the similar values as the values in that column.
    Please see the pictures.

    Thank you,

    Ch.
    Attached Images Attached Images

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 8
    Last Post: 05-02-2022, 02:21 PM
  2. Replies: 3
    Last Post: 11-24-2021, 02:22 AM
  3. [SOLVED] Power Query Unpivot Workbook Tables with Date Column Headings
    By MarvinP in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-16-2021, 10:52 AM
  4. Replies: 1
    Last Post: 08-10-2021, 02:08 AM
  5. Add sheet name as a column in appended tables in Power Query
    By Glenn Kennedy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-20-2021, 03:05 PM
  6. Power Query: Updating a query based on changing tables
    By cheesehead101 in forum Excel General
    Replies: 1
    Last Post: 12-16-2019, 06:54 PM
  7. Replies: 9
    Last Post: 11-29-2017, 01:32 PM

Tags for this Thread

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