How to group data from multiple sheet

[Luca999]

I kindly ask if there is a way to group the data from Sheet1, Sheet2, Sheet3 in a recap Sheet4.
I would like to recap only some column, the issue is that the data are in horizontal and I would like to have them in vertical.
I try to put an example here and I attach the file I'm using to be more clear.
Thank you so much for any kind of support!

Sheet1:JOB_Equipments

​	A​	B​	...​	N​	O​	P​	Q​	R​	S​	T​	U​	V​	W​	X​	Y​	Z​	AA​	AB​	AC​	AD​	AE​	AF​	AG​	AH​
1​	​	​	​	x​	x​	x​	x​	x​	x​	x​	x​	x​	x​	x​	x​	x​	x​	x​	x​	x​	x​	x​	x​	x​

Sheet2:JOB_After Sales

​	A​	B​	...​	N​	O​	P​	Q​	R​	S​	T​	U​	V​	W​	X​	Y​	Z​	AA​	​	​	​	​	​	​	​
1​	​	​	​	x​	x​	x​	x​	x​	x​	x​	x​	x​	x​	x​	x​	x​	x​	​	​	​	​	​	​	​

Sheet3:Customer Complaints

​	A​	B​	...​	H​	I​	J​	K​	L​	M​	N​	O​	P​	Q​	R​	A​	T​	U​	​	​	​	​	​	​	​
1​	​	​	​	x​	x​	x​	x​	x​	x​	x​	x​	x​	x​	x​	x​	x​	x​	​	​	​	​	​	​	​

Sheet4:Interventions Recap (to be generated)

​	A​	B​	...​	F​	G​	H​	I​	J​	K​	L​	​	​						​	​	​	​	​	​	​
1​	​	​	​	x​	x​	x​	x​	x​	x​	x​	​	​	​	​	​	​	​	​	​	​	​	​	​	​

 

[Marc L]

To be explained at least …​

​

 

[Luca999]

Sorry my bad explanation.
I have 3 sheets in the same workbook, I would like to take some informations from these sheet and summarize them in a new sheet.
Each sheet contains the same informations but structured in a different way.
Furthermore some data are in horizontal and I would like to have them in vertical.

I try put a better example here:


Thank you so much!!!

 

[vletm]

Luca999​

Your 3rd sheet has two extra columns (TYPE & OVERALL STATUS).
... plus there are two times those seven columns.
Why You won't use it?
... or what to do with those other seven columns.
You sample data has many empty cells.
Is Your 4th sheet ... vertical?
... is something else then please, how would it look vertical?
Could You show some expected correct result based Your given data?

 

[Luca999]

Luca999​

Your 3rd sheet has two extra columns (TYPE & OVERALL STATUS).
... plus there are two times those seven columns.
Why You won't use it?
... or what to do with those other seven columns.
You sample data has many empty cells.
Is Your 4th sheet ... vertical?
... is something else then please, how would it look vertical?
Could You show some expected correct result based Your given data?

Thx for your reply vletm.

Why You won't use it?
Because in my 4th sheet I don't need these info, I would like to have a recap of some.

what to do with those other seven columns.
I'm intersted to see the "inteventions" informations

You sample data has many empty cells.
Yes it is true, I have to fill the "interventions" info, this is the reason I would like to have a recap.

Is Your 4th sheet ... vertical?
Yes, exactely, this is my difficulties, I would like to recap the "intervention" info in vertical.

... is something else then please, how would it look vertical?
Could You show some expected correct result based Your given data?
I try to put here an example of the sheet filled.

Thank you!!

 

[vletm]

Luca999​

Isn't Your 4th sheet layout still horizontal?
If You want to avoid see some columns then those columns could hide for those moments
Or
Do You have an image to show possible 2nd intervention below 1st intervention?
... then do You really need to see those A...E-columns twice?

 

[Luca999]

Luca999​

Isn't Your 4th sheet layout still horizontal?
If You want to avoid see some columns then those columns could hide for those moments
Or
Do You have an image to show possible 2nd intervention below 1st intervention?
... then do You really need to see those A...E-columns twice?

The 4th sheet still horizontal but the "intervention" info are vertical.
There is no more 2nd or 3th "intervention" but only one column "intervention" and the 2nd or 3th should fill one below the other.
Like this:

A E columns are important for me to see the job informations.
Thank you so much!

 

[vletm]

Somewhere is possible 3rd intervention too ... hmm? ... where?
Do You really have already three times same data?
... or How You control that data is there once?

 

[Luca999]

In Sheet1, Job Euipments there are 3 intervention possibility.
What I would like to do is this:

Sheet1:

ID​	INFO1​	INFO2​	INFO3​
APPLE​	GREEN​	YELLOW​	RED​

Sheet2:

ID​	INFO1​	INFO2​	INFO3​
PEAR​	GREEN​	YELLOW​	RED​

Sheet Recap:

ID​	INFO​
APPLE​	GREEN​
APPLE​	YELLOW​
APPLE​	RED​
PEAR​	GREEN​
PEAR​	YELLOW​
PEAR​	RED​

Thank you!

 

[vletm]

Three questions ... You answered to the 1st one.
but
Only Sheet3 has ID information.

If follows Sheet1's JOB 1155, which have three places for intervention.
from Sheet2 can find three rows data based REFERENCE JOB 1155, which each have ? separate ? three places for intervention - total nine or are those same?
Sheet3 misses REFERENCE JOB 1155 ... but there could be two places for intervention per ID

> Ideas? <

 

[Luca999]

Sorry,
Do You really have already three times same data?
... or How You control that data is there once?
Sheet1 is the main DB, Sheet2 and Sheet3 grab some info from this DB.
The informations different from each sheet are the "intervention" info

Only Sheet3 has ID information
Yes you are right, we can rename the "ID" in "JOB" same of other sheet.

If follows Sheet1's JOB 1155, which have three places for intervention.
from Sheet2 can find three rows data based REFERENCE JOB 1155, which each have ?
If follows Sheet1's JOB 1155, which have three places for intervention, in sheet4(the recap) I should have three rows data.
Not necessary I can found REFERENCE JOB 1155 in sheet2.

Sheet3 misses REFERENCE JOB 1155 ... but there could be two places for intervention per ID
Not necessary in sheet3 there could be REFERENCE JOB 1155 but yes there are two places for intervention.

For example for JOB1155, we can have from a minimum of zero intervention to a max of 8 interventions.
from 0 to 3 can be in sheet 1
from 0 to 3 can be in sheet 2
from 0 to 2 can be in sheet 3

Thank you!

 

[vletm]

Still too many ... hmm?
# grap ... yes?
# Naming ... really? check below snapshot

# number of those interventions ... are different than You wrote or how?

 

[Luca999]

# grap ... yes?
I meant that some info in sheet2 and sheet2 are VLOOKUP from sheet1.

# Naming ... really? check below snapshot
We can rename "ID" in "JOB", so the initial colum will be "JOB" and "REF. JOB"

# number of those interventions ... are different than You wrote or how?
Your example is perfect, yes you are right sorry, it is exactely as for your example.

Thx!

 

[vletm]

# grap ... yes?
... and have huge file.
As well as there are some dropdowns.
Skipped question: How You control that data is there once?

# Naming ... really? check below snapshot
... hmm? Did You follow 1155?
Do it matter if there will lost some connections with sheets?

# number of those interventions ...
... but after Your renaming ... there will be a challenge.
Do You recalculate - max three ... but per which?
> my snapshot >
if per 1155 then - what is 8011?
there were none reference to row 13 - that's possible.

 

[Luca999]

# grap ... yes?
... and have huge file.
As well as there are some dropdowns.
Skipped question: How You control that data is there once?

# Naming ... really? check below snapshot
... hmm? Did You follow 1155?
Do it matter if there will lost some connections with sheets?

# number of those interventions ...
... but after Your renaming ... there will be a challenge.
Do You recalculate - max three ... but per which?
> my snapshot >
if per 1155 then - what is 8011?
there were none reference to row 13 - that's possible.

How You control that data is there once?
The sheet check that the Job n° is insered only one time, if not there conditional formatting that make the cell red.

Do it matter if there will lost some connections with sheets?
it is important to keep VLOOKUP between sheet1 sheet2 sheet3

Do You recalculate - max three ... but per which?
if per 1155 then - what is 8011?
8011 is a sequential number referred to a spare part linked to JOB1155.
Effectively we can have more that one spare part for JOB.
But not all the spare part requires an intervetion.
Some yes, some more than one, some zero.

Thx!

 

[vletm]

Luca999​

There are still too many 'how this should work?'-cases
... before I could figure - how/which to group something?
... plus many more eg how any 'equipment' could give 'Final Country'.
There should be clear connections between those which could group.
I did 'minor' modifications to Your file.
Job-sheet has 'yellow'-cell - test it.
There are none VLOOKUPs ... those can do other way.
There only few dropdowns ... those can do other way.
Those Formulas ... those can do other way.
I've collected Your DB* -sheets to one sheet ( that needs to modify! )
Your We can rename "ID" in "JOB", so the initial colum will be "JOB" and "REF. JOB" ... maybe You can - but not me!
That file needs many modifications.
Questions?

 

[Luca999]

Luca999​

There are still too many 'how this should work?'-cases
... before I could figure - how/which to group something?
... plus many more eg how any 'equipment' could give 'Final Country'.
There should be clear connections between those which could group.
I did 'minor' modifications to Your file.
Job-sheet has 'yellow'-cell - test it.
There are none VLOOKUPs ... those can do other way.
There only few dropdowns ... those can do other way.
Those Formulas ... those can do other way.
I've collected Your DB* -sheets to one sheet ( that needs to modify! )
Your We can rename "ID" in "JOB", so the initial colum will be "JOB" and "REF. JOB" ... maybe You can - but not me!
That file needs many modifications.
Questions?

I like a lot your approach, thank you so much!

... plus many more eg how any 'equipment' could give 'Final Country'.
"FINAL COUNTRY" is from a drop down list, it is in DB sheet is the column called "PAESE".

In this way everything seems faster and leaner now!
I try to approach this way.

Thank you so much!

 

[vletm]

Luca999​

Okay ... none questions.
Few same notes:
# 'grouping' is missing as I wrote
# my eg ... You answered something else
# That file needs many modifications.

 

[Luca999]

Luca999​

Okay ... none questions.
Few same notes:
# 'grouping' is missing as I wrote
# my eg ... You answered something else
# That file needs many modifications.

Noted, thank you so much for your support!