Adding rows with advanced filters

%3CLINGO-SUB%20id%3D%22lingo-sub-1627715%22%20slang%3D%22en-US%22%3EAdding%20rows%20with%20advanced%20filters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1627715%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20told%20that%20is%20possible%20using%20filters%26nbsp%3B%20(advanced%3F)%20to%20add%20rows%20based%20on%20a%20cell%20in%20a%20column%2C%20but%20I%20cannot%20figure%20out%20how.%20I%20cannot%20use%20macros%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20is%20a%20list%20of%20people%20that%20made%20some%20activity%2C%20someone%20just%20one%20day%2C%20other%20more%20than%20one%20day.%3C%2FP%3E%3CP%3EBased%20on%20the%20numer%20of%20day%20that%20he%20worked%2C%20how%20can%20copy%20the%20row%20below%20the%20first%20date%20as%20many%20times%20the%20date%20on%20the%20colums%20appears%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20attached%20the%20source%20file%2C%20the%20goal%20is%20to%20have%20just%20one%20row%20for%20each%20day%2C%20not%20single%20row%20and%20columns%20with%20the%20dates..%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20is%20clear.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3CP%3ED.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1627715%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Visitor

Hello,

 

I was told that is possible using filters  (advanced?) to add rows based on a cell in a column, but I cannot figure out how. I cannot use macros

 

There is a list of people that made some activity, someone just one day, other more than one day.

Based on the numer of day that he worked, how can copy the row below the first date as many times the date on the colums appears?

 

I have attached the source file, the goal is to have just one row for each day, not single row and columns with the dates..

 

Hope is clear.

 

Thanks in advance

D.

0 Replies