0

I am running into issues with a fairly simple QUERY statement in Google Spreadsheets. The goal is to get data (unique cells/values) from different sheets (same file). The example shows that I am using the cell reference from two sheets.

=QUERY({TeamScaled!I:I,TeamRx!M:M, TeamLeadScaled!I:I, TeamLeadScaled!M:M},)

The result: data gets distributed in 4 (E,F, G, H) columns and not 2 (E & F). How can I bring everything to E and F? I tried separating sheets by a semi-column but that wipes off the data.

Sample Image

Simba1309
  • 11
  • 4
  • Welcome to [so]. Instead of adding sample data as image, add it as text. Use markdown to format it as table. It's not clear what you mean by "sem-column" (did you tried to say semi-colon `;`)?. What is the spreadsheet locale / country or your spreadsheet? – Rubén Jan 06 '23 at 22:33
  • If you are looking to get unique values use UNIQUE instead of QUERY. – Rubén Jan 06 '23 at 22:38

0 Answers0