excel data manipulation

Hi All! I am new to the forum and BI, but this is what I'm working with: 1. We receive/download approx 23 files per day from a vendor share site - combo of csv/excel & pdf reports (though naming conventions are NOT consistent) 2. We have a daily tracking sheet of numerous rows we maintain and...

I am needing help re-arranging data in one sheet in the format of another sheet. The issue is I need one row broken down into multiple rows that all tie to the inventory number associated This the sheet I need to format. This is the format I need to get to.

I am very new to Excel so please excuse the limited knowledge of asking this question within this community. I have a Column that contains emails in each row, however SOME of the rows contain the website url as well. I can't figure out HOW to separate the website into its own column while...

Hi All, Need a urgent help : Need excel formula for the below three condition. I have two column A & B CritDate and Value : if the if CritDate deliveries in current week the Value = text "CDCM /DCW" if critical date deliveries is in current month then Value = text "CDCM" Critical date...

HiI need to transpose some data as follows, for which a normal transpose doesn't seem to work.I have cost centre in column A, Account Code in column B, Description in column C, and then column D to O has values phased by month (Jan-Dec) with headings in row 1.What I want is to transpose this so...