jnix612
04-13-2020, 11:31 AM
I am using query for the first time and managed to do a pretty decent job. I have 5 sheets I am consolidating into a master (all on the same spreadsheet).
Each sheet is identical
Rows 1-4 are instructions
Row 5 as the headers
I would like to use row 6 on each sheet as example text. I do not want query to consolidate row 6 from any of the sheets. Is this possible?
Each sheet is identical
Rows 1-4 are instructions
Row 5 as the headers
I would like to use row 6 on each sheet as example text. I do not want query to consolidate row 6 from any of the sheets. Is this possible?