newbie question

Hi folks. About 3 weeks ago, I began to try and learn how to use power query, and while I think I'm slowly getting the basics, I cannot for the life of me figure out how to do what would be an insanely easy task in Excel. I have a fairly large database that I'm working with, and am trying to...

Hello, I am seeking some help with a formula based on the inputs in the sample below. The "SHOPIFY IMAGE DATA" sheet data remains in sequential order when imported... S4,S5,S6,S7 etc. However the reference for sheet "SHOPIFY PRODUCT TITLE" only changes reference every 12 rows... S4,S16,S28...

I'm an Excel 365 user, and a very new one at that. Forgive me for my lack of etiquette within this forum, I hope that this first post may help introduce me to a way to solve this specific problem of mine, as well as to learn more about Excel 365 in general, and how to properly interact with this...

I am a beginner to Power BI and really appreciate your help. I have 20 offices. Each office has 5 units and each unit has 3 sub units. I set up the following lookup tables: Office - office #, city, state, region Unit - Unit # and Sub # The Office lookup table works and slices and dices all...

This is probably a dumb question but I have a large set of numbers in an excel spreadsheet that are in the wrong format for what I need (ng/ml instead of uM/L). Is there a simple way to convert all the numbers in the spreadsheet? I know what formula to use, just no how to easily apply it to...