consumer

I'm trying to merge two tables together. One is a customer list and another is a product list. I want to combine the two and expand the customer list with the product list. How would I do this in power query. Customer List <tbody> Customer Product List Customer1 Food Customer 2 Consumer...

Trying to figure out the best way to turn my rows into columns, while maintaining the values and headers. Looks like a reverse crosstab query or something. I'm an amateur btw... I have about 35 columns that I want to stay the same (keep as columns), then about 50 column that have months...

Hi there, I want to know if there's a way to brake-down to components a data table according to weight? I have a portfolio of equities and etf's (table 1) , and I want that every ETF in it will be 'opened' according to the weights (table 3) of its related index (table 2) , so I'll get a table...