$tempansarr[$ansobj->question_id] = $ansobj->answer_text; } foreach ($usa->categoryvendoranswer as $catansobj) { $tempcatansarr[$catansobj->categoryvendor_id] = $catansobj->answer; } $useransarr[$usa->id]['login'] = $usa->email; $useransarr[$usa->id]['id'] = $usa->id; $useransarr[$usa->id]['answers'] = $tempansarr; $useransarr[$usa->id]['catanswers'] = $tempcatansarr; // dd($useransarr[]); } //dd($userswithanswers); // $questions = Question::all(); // $users = User::whereIn('id', $user_ids)->get(); $questions = Question::orderBy('page')->where('event', '=', $exceleve)->where('page', '!=', 0)->orderBy('order')->get(); $categoryvendors = Categoryvendor::all(); // HEADER ROW FOR FOR EXCEL $header1 = array(); $header1[] = ''; $header2 = array(); $header2[] = 'Login'; $preprojectnumber = ''; foreach ($questions as $header) { /*echo $header->class_name."<br>"; echo $header->question_group."<br>";*/ if ($header->class_name != 'projects checkbox group') { //echo "1"; $header1[] = $header->question_group; $header2[] = $header->question_text; } else { if ($header->question_group != $preprojectnumber) {