Help with Data consodilation into 1 column

Please amned you file to SHOW us what your expected results are. The picture means nothing to me.

The file is already added in the post it's link is just beside the image

How do you deduce from this all of the details in the columns in the summary report???

AliGW on MS365 Beta Channel (Windows 11) 64 bit

	B	C	D	E	F	G	H	I	J	K
2	R&D_Trial_ACC
3	Form detail
4	Form detail report
5
6
7	Created on			19 Mar 2024, 12:33 EET
8	Created by			Ahmed Fayad
9	Total items			1
10	Filtered by			Customised selection

Sheet: Overview

I can see the file and open it. I do not understand WHAT you want.

What do you expect to see?
Where do you expect to see it?
Please amend your sample file appropriately.

Originally Posted by AliGW

How do you deduce from this all of the details in the columns in the summary report???

I don't understand what do you mean exactly, But there is no problem in the "Overview" sheet the problem is in the other sheet only

Yes, I know - but where is all the data that you want under Buldings in the other sheet supposed to come from? Or go to? What EXACTLY is the 'problem'? You have not articulated this at all.

Mock up WHAT you want to see WHERE you want to see it in the sample workbook.

The data is downloaded as an Excel, It's a form online and i download its data in Excel, I want it to look like this instead of Building , Building 1, Building 2,.... etc

I want it to be Building and under it the data of Building , Building 1, Building 2
Attachment 864125

So you want a copy of that data in a different format - yes?

Yes, I want to use this data and put it in another format, Not sure if it can be done in the same sheet automatically where excel reads the columns headers and if they have the same name like Building _ then put them all in the same column under Building if that's not possible, Then to create another sheet and adding the headers and transposing the data under these columnes

So attach a file (as requested already) that shows us EXACTLY how you want it to look.

Form detail report (4) (3).xlsx

Here is the file, I want it to be like in the Data Sheet.

The following formula works for the sample provided:

Formula:

Please Login or Register  to view this content.

Note that the range A7:K16 is custom formatted General;;
Let us know if you have any questions.