1

I have tried this example to merge two tables into one but can't seem to avoid the merged data overwriting existing rows.

Is there a way to make sure, that merged rows are inserted like new rows? Here's my own working example

Allan Bech
  • 391
  • 1
  • 6

1 Answers1

0

Position staff in row time:

={First!A2:F2; array_constrain(sort({Staff!A3:A9,Staff!B3:F9,row(First!A3:A9)-row(First!A1);
FILTER (
{ 
 left(First!A1:A9,0) & First!A1 ,First!B1:F9,row(First!A1:A9)-row(First!A1);
 left(Second!A1:A9,0) & Second!A1 ,Second!B1:F9,row(Second!A1:A9)-row(Second!A1);
 left(Third!A1:A9,0) & Third!A1 ,Third!B1:F9,row(Third!A1:A9)-row(Third!A1);
 left(Fourth!A1:A9,0) & Fourth!A1 ,Fourth!B1:F9,row(Fourth!A1:A9)-row(Fourth!A1)

},
{  
   row(First!A1:A9)-row(First!A1);
   row(Second!A1:A9)-row(Second!A1);
   row(Third!A1:A9)-row(Third!A1);
   row(Fourth!A1:A9)-row(Fourth!A1)
}>1,
   {
     First!A1:A9;
     Second!A1:A9;
     Third!A1:A9;
     Fourth!A1:A9
   }<>"")}   ,7,1),1000,6)}
user11982798
  • 1,878
  • 1
  • 6
  • 8