Forum

Hello Tom, Just took a quick glimpse of your sample file. If you are able to get the hours data in a tabular format + in that data also have the em...

Hi, You can check at Microsoft's web page when a function was introduced. Br, Anders

Hello Santosh, Thanks for your feedback. Glad you found the duplicate entries, it is tricky sometimes. Br, Anders

Hello Mark, Thanks for the feedback. It is just a pleasure to be able to give some help. Br, Anders

Hello, I can only assume that there are duplicate data in your file, but this is just an assumption. You can always use the Remove duplicates after...

Hello Mark, In Power Query Editor, select the Category column and in Transform menu, click Pivot Column. In the dialogue box, pick Value as the col...

Hello Steve, The INDEX/MATCH formula that Sunny has provided to you works just fine, using the helper column in Codes sheet. The reason to the #N/A...

Hello Maja, It is of course doable using formulas to get this view you want, but it is not recommended as it requires manual work to extend or upda...

Hello, I would use a Pivot Table for such and also have the data in an Excel table so that the Pivot Table is updated dynamically when new data is ...

Hello, I suggest you work with your data in a tabular format and then use a Pivot Table to summarize the sum per month. https://www.myonlinetrain...

Hello, Actually, the formula provided by Sunny and the formula having CONCATENATE is doing just the same thing. The blog article linked too below g...

Hello, I don't know if there is a template available suitable for your needs, but I usually look here first.

Hello, If you haven't already, do read this article. The blog section is a treasure box.

Hello Kenneth, I try to give you an answer as this is gives me a good training in using Power Query. The steps I used is visible when you choose to...

Hello, I assume you then use the .xls file format. It does have its limitations. The .xls file format only support a limited number of 7 nested fun...