multivalued fields

Hi there. Long-time Excel user and dabbler in VBA who discovered Power Query for the first time today. I've used this to combine values spanning multiple rows into single row entries with multi-value fields/cells. An example should be helpful: Here's a mock-up of my source data. Column A...

Is it possible to incorporate multivalue fields in a 'make table' query? Essentially, I have a list of clients that are processed in various months. The months they are processed to not always follow a pattern. So, I stored the months they are processed are in a single multivalue cell in Table...

Hi there. I have a novel issue and haven't found any threads that touch on it. I'd like to concatenate the corresponding contents of multivalue cells across four columns. A simple illustration of my data will be helpful: Cell A2 Boston; New York Cell B2 Pizza Regina; White Castle Cell C2...

I'm trying for a few days to get this done right, so I thought I should ask for help in this forum. So, I have 2 tables like this: Table1 with 2 columns: OrderID(alphanumerical formatted as text) and Price($) Table2 that has a column ServiceID (number), and Orders (same as OrderID, but...

Hello, I have a column with multiple values imported from access. A1: 4;10;8 A2: 5;4;1 A3: 2;13;4 A4: 4 I need to count how many times each value appears in the list. I am trying to use the countifs statement because I only want to count values who meet criteria defined in a seperate...