spalmerIron ContributorSep 17, 2025Excel Formula Help Hi everyone, i am needing help pulling data from one sheet to another. The "DATA" tab is a bunch of data that is pulled from a Microsoft forms survey and i copy and paste it in the sheet. Once i copy...Show MoreTest Spreadsheet.xlsx62 KB
Harun24HRBronze ContributorSep 18, 2025Try the following formula-=LET(x,FILTER(OfficeForms.Table[[Module]:[Comments]],(OfficeForms.Table[District]=A1)*(OfficeForms.Table[Job Code]=C1)), HSTACK(TOROW(TAKE(x,,6),3),TAKE(x,,-5))) Test Spreadsheet.xlsx61 KB
