Get instant live Excel expert help with COLUMNS Function

Need a formula to combine multiple rows of sheet2 into multiple columns on sheet2 as single row.

While adding columns to excel 2013 page the whole page disappeared and turned blue. What could have caused the problem and can I recover the page?

I have 12k rows with 17 columns of data. I have multiple weeks of data I need to compare. First I need to reduce my rows depending on criteria listed in different columns. Then I need to compare the remaining data as to what new rows I have gained each week and what rows I have lost each week.

MAC OSX MS Office 2011 - I have one (v.important) spreadsheet that has become VERY slow and unresponsive. It's 3000 lines x 12 columns. It has remained this size, but with different data, for several years without issue. All cells just data except two cols with a very simple formula in. No macros. Copying one cell to another takes minutes. Copying, say 5 cells hangs up, copying more crashes. Tried opening in Open office and Apple Numbers and Excel on a different (windows) machine. More or less same result. Other spreadsheets OK. Have set calculation to manual. Any ideas?

Trying to summarize deposit totals or credit totals and not simply totals in both columns - deposits and check amounts

I have spread sheet with 100k records and in that I have 47 columns so how to check my data quality For Ex blank values in different columns with same rows or Different rows with same columns

Hi... I have excel sheet with certain keyword in multiple columns. I wanted to filter those rows containing the specific keyword in any of the columns.

I've got a misbehaving spreadsheet that won't allow copy without either slowing right down or crashing. Original file is around 3500 lines and 15 columns but for testing I've cut this right down...eventually to just one cell. Still have same problem.

Check register. Columns for checking amount and checking balance formula =D2864+C2827 gives answer in D2864 D2864 = 1044.16 C2827 = -509.49 Evaluation of 1044.16+-509.49 gives 1044.16 Calculation is automatic Format is numbers, 2 decimals in all cells Dragging formula gives same answer as above Entering same formula gives correct answer of 534.67

I have a file that has three tabs of misc formulas for calculating profit. Tab 1 = Income , Tab 2 = Expenses, Tab 3= Profit. Each tab has multiple calculations based on various inputs. The main variable I want to change is the “Run Time” This changes the amount of income and expenses based on that. I’m trying to make a 4th tab that has a chart of 5 or so columns of different run times. I want to be able to enter say 5 different run times and have it populate chart with profits (income and expenses too) for each run time in this chart.