merge cell based value

I'm looking for a formula that will help me return the merged cell value for every question that is next to a particular merged cell. See image below. I have huge sets of questions and areas sheets that I get sent. And just looking to use formula to help me arrange the data the way I need Thanks

Hi Gurus, Good day! Could you provide your insight on how the macro can paste the data from a worksheet to another with merge cells? Workflow: 1. I have a main data worksheet and files to update. Files to update on this case is same with State provided in Source worksheet. All State data...

Good afternoon, I'm currently trying to merge two columns that have similar Article ID's, but one list has 17.000+ positions, the other only has 13.000+ positions. All 13.000 match the ID from the first list. Basically I want to add the new columns from a different database and match them with...

Hello Community, I have this project where I have different tables with data in them and would like to summarize them in one table. What would be the best way to achieve this and make the solution as robust as possible? Key elements that are good to know. 1) Those tables are manually fed. 2)...

Hello, I have varies list of equipment, I have done background calculation to determine hourly, daily, weekly, or monthly rate will apply to this equipment. I have "D" for daily, "H" for hourly, "W" for weekly, and "M" for monthly. Based on cell value "W" or "M" I want to merge Week row for...

Hello, I have a workbook that contains classes a person must take based on their roles in a system (job duties). Because each roles requires certain classes and all of the roles have repeated classes, I would like to combine the rows based on the user while keeping all unique values and keeping...

can anyone help me on following problem, i highlighted rows with conditional formatting, any row with date on sunday is highlighted, i want excel to merge cells C,D & E on sunday,plus show "Sunday" in highlighted cells as well. Please help.