Forum

Hi Jacek, Have you tried merging the columns? Nulls should be replaced with the values. Mynda

Hi Catherine, There's no image attached. You need to click the 'Start Upload' button after selecting your file. However, as this is a technical iss...

Glad you got it working, Norman!

Hi Lea, In that case it'll be other names throughout the query causing the problem. e.g. the worksheet names are different in each of those files. ...

Hi Norman, You can use Power Query to split the columns into rows by the semi-colon delimiter. If you need help with this, please upload a small sa...

Hi Lea, I can't read your files as I don't speak Hebrew, but that error means that the column labels in the second file don't match those that the ...

Hi Leslie, Yes, I cover best practices and chart types etc. in my Excel Dashboard course. There's no minimum number of columns for datasets to b...

Hi Sha-abaan, Welcome to our forum! You need to fix the layout of your source data so that the column labels, 1,2,3... are in their own column a...

Hi Eric, When you unpivot, instead of selecting the columns to unpivot, select the columns you don't want to unpivot and then select 'Unpivot Other...

Hi Sai, I would strongly advise against copying the data again. This will only result in a bigger, slower file. In the PivotTable you can set th...

Hi Francis, Please start a new question/topic in the Power Pivot forum and include a sample file. Thanks, Mynda

Hi Maarten, It's difficult to say definitely that the relationships are the right way around in the model because your fact tables aren't obvious f...

Hi Lisa, Please see file attached. Note the order of the rules is important. Set them up starting with 0%. Check the Conditional Formatting Rules M...

Hi Bruno, Please refer to this tutorial on Grouped Running Totals in Power Query and modify the formula to subtract rather than add. Mynda

Ah, that's annoying.