Are you stuck on Excel or Google Sheets?

[REPOST] Hi, I have a list of names in 1 column, with title, company, etc in a row and each person has multiple emails. Each different email is in a different column. I want to copy each row and align each different email so the email is in the same column with name, title etc repeating.

I need to count unique, non-numeric values from a dynamic column.

I have a very large excel spreadsheet consisting of copious amounts of data. To make a really long story short, I need to eliminate all single values in one particular column in my spreadsheet. By "single value" I am referring to single letters, such as "A", "B", "C" etc. These are the middle names of the spreadsheet, and I need to get rid of them for a specific column. Because there is so much data, it is unrealistic for me to do this manually. These single value letters are in the same column as regular word values with full last names, so I can't just delete the entire columns without getting rid of the regular names that I want to keep. So is there any kind of Excel function that allows me to delete the single values only? Thanks.

I am having issues creating the one way data table to show the means and standard deviations when you change the proportion of portfolio 1. I have the mean formula and the standard deviation formula at the top and -1 through 1 down the left side. I highlight all of it and create a data table. I reference the "proportion of portfolio 1" cell in the column input box but when the data table comes out it has all the same numbers all they way down the table.

I need to analyze data in this file. Companies’ column A and part in column F. Which companies have both Part A and Part B, Which have only Part A, which have only Part B. Top 10 Part A companies.

I have a column containing date and time data together and i need to isolate the time data. When I tried to use text to column, it changed all the times to AM. There is an extremely large amount of data - over 550,000 rows so manually changing it won't work. The file is too large to attach.

Greetings, I am trying to find a formula in excel that will return the number of students attending courses. My data is on one sheet and my report will be on another sheet. The report is formated with the students list in a coulmn (far left), the courses are list in a row (top). My data is formatted with all columns, courses in column in "A" and students in column "B". Thanks

indexing multiple rows of data from criteria in a column (need to be able to bring up multiple job specifics [each job has its own row] by searching in the "due date" column for jobs due between start date and end date

i need to compare numbers in 2 columns 400+ lines and have it report either 'in' or 'out' based on the outcome of the comparison of the two formulas. one is a signed out column abd the other is the products that are returned

how to paste a formula from one column to another