rows multiple columns

I have a range of participants who all have unique identification numbers and they have taken multiple speaking series classes. These classes are listed on an excel worksheet with different rows. I want to concatenate them all together using the primary key as the unique identifier so that they...

I'm using Excel2007. With the exception of my headers, only column AC (sometimes) wraps to multiple lines based on input data. Several columns are protected. Rows 1 thru 3 and cols A & B are frozen to always be visible. How can I print only certain cells & only in rows with increased row...

Hey folks! I have columns of sales data (text), and then dates across columns as well. I want to take those dates and format them into one row so each date matches up to each row of text data. Below is a sample of some of the data, but I have 171 rows would like reformatted and dates from...

I'm using Excel 2013/Windows 7 and I think I'm looking for a macro here but you tell me... I have a large list of employee changes (hires and terminations) from the past two years where almost all employees are listed more than once. For example, if someone was a new hire, then terminated, then...

Hi all, i've got a worksheet "patiënts" where in each row fore some columns (hours) a therapist is defined. Now i want to generate a new tab where i can see for each therapist the time and the patiënts he/she needs to treat. From ther i can generate a planning overview If there is a moment...

Hi, Can you please help?, I need a macro for excel 2007 I have a spreadsheet that has only one row and about 850 columns containing names job titles and a further 9 columns of details) I need to convert this: name_1 jobtitle_1 email_1 phonenumber_1 fax_1 example _1 name_2 etc to...