Formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-1316716%22%20slang%3D%22en-US%22%3EFormatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1316716%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20set%20up%20a%20COVID%2019%20last%20minute%20ordering%20site%20and%20the%20orders%20can%20be%20exported.%20The%20issue%20is%20the%20file%20comes%20in%20a%20very%20impractical%20format.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20be%20able%20to%20highlight%20for%20example%20'beer'%20and%20then%20know%20how%20many%20there%20are%20on%20order%20in%20total.%20I%20have%20conditional%20formatted%20the%20word%20Beer%20to%20come%20up%20in%20Red%2C%20but%20is%20there%20a%20way%20of%20being%20able%20to%20get%20excel%20to%20then%20collate%20all%20the%20Beers%20and%20the%20cell%20next%20to%20it%20(with%20the%20amount)%20to%20one%20place%20so%20instead%20or%20trawling%20through%20every%20one%2C%20Excel%20can%20group%20them%20all%20together%20so%20I%20get%20a%20total.%20I%20am%20also%20having%20the%20same%20issue%20with%20the%20delivery%20dates.%26nbsp%3B%20In%20summary%2C%20I%20want%20the%20spreadsheet%20to%20be%20able%20to%20spit%20out%20same%20delivery%20day%20orders%20together%20and%20also%20be%20able%20to%20do%20summary%20of%20total%20products%20ordered.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1316716%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Hi there,

 

I have set up a COVID 19 last minute ordering site and the orders can be exported. The issue is the file comes in a very impractical format. 

I need to be able to highlight for example 'beer' and then know how many there are on order in total. I have conditional formatted the word Beer to come up in Red, but is there a way of being able to get excel to then collate all the Beers and the cell next to it (with the amount) to one place so instead or trawling through every one, Excel can group them all together so I get a total. I am also having the same issue with the delivery dates.  In summary, I want the spreadsheet to be able to spit out same delivery day orders together and also be able to do summary of total products ordered. 

1 Reply
Highlighted

Hi@bexTDK,

 

You need to connect you source file with the Power Query which in Data Ribbon Tab for Excel 2016 Onward Data>Get Data>From FILE >CSV/Text

 

You can clean and shape your data as you like, load the data into excel then do your analytical part. 

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more