Forum

Hello, There are of course different techniques to handle data import to Power Query, which I still regard as the best solution for you. Import Mul...

Hello, What is the issue? What formulas have you tried with? In general, if the year is irrelevant, add a helper column which takes the month an...

Hello Salim, No file was uploaded. Br, Anders

Hello, The best and probably easiest solution is to use Power Query by loading the data from files in a folder. Br, Anders

Hello Zita, What do you mean with the Owner column? Br, Anders

Hello Francis, I have re-arranged your data table and is using a Pivot Table to view and filter the data, see if this approach works for you. Ha...

Hello Frederic, Sorry, the picture didn't upload correctly. Instead of a picture, it is better if you can upload a sample file, no need for real da...

Hello, Simplest solution is to just use Name, Population etc, skipping the need to use Town or City. Br, Anders

Hello Prasad, I am happy to try to help, but that requires you to try on your own to solve the issues and need help to get pass the obstacle that i...

Hello, This looks like a school project, but you can use the INDIRECT function together with &"Slabs" to connect to the different slabs tables,...

Hello, The only solution I know of being reliable enough is to add numbers to the text you want to sort by. See attached file for an example. Br...

Hello, Just dropping by to write that I can not find any clue in your .xlsm file to why the description text gets truncated. I can not replicate th...

Hello, The Pivot Table (PT) only shows the data from the source table, so you need to change in the source and then update the PT to get the new va...

Hello, You should arrange your data in a tabular format, see example in attached file. If you want the layout as you have built in your table, then...

Hello, When importing the daily file to a new file it works just fine, I get over 1,000 characters without any issue. The same when I create severa...