coping data in rows into vertically in another sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2470724%22%20slang%3D%22en-US%22%3Ecoping%20data%20in%20rows%20into%20vertically%20in%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2470724%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20stuck%20in%20copying%20or%20linking%20data%20in%20between%20different%20sheets.%3C%2FP%3E%3CP%3Eplease%20help.%3C%2FP%3E%3CP%3Eplease%20open%20the%20file%20to%20understand%20the%20nature%20of%20the%20problem.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2470724%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2473795%22%20slang%3D%22en-US%22%3ERe%3A%20coping%20data%20in%20rows%20into%20vertically%20in%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2473795%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1085356%22%20target%3D%22_blank%22%3E%40subhaNew%3C%2FA%3E%26nbsp%3BI%20believe%20Power%20Query%20can%20fairly%20easily%20do%20what%20you%20need.%20With%20a%20slight%20modification%20to%20the%20data%20table%20you%20can%20create%20output%20similar%20(though%20not%20exactly%20the%20same)%20to%20what%20you%20described%20in%20the%20FOIL%20tab.%20See%20for%20yourself%20in%20the%20attached%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2480890%22%20slang%3D%22en-US%22%3ERe%3A%20coping%20data%20in%20rows%20into%20vertically%20in%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2480890%22%20slang%3D%22en-US%22%3EThanks%20for%20your%20help%3CBR%20%2F%3ERiny_van_Eekelen.%3CBR%20%2F%3Elet%20me%20try%20it...%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2480989%22%20slang%3D%22en-US%22%3ERe%3A%20coping%20data%20in%20rows%20into%20vertically%20in%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2480989%22%20slang%3D%22en-US%22%3EIs%20there%20any%20other%20way%20to%20do%20that%20%3F%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
New Contributor

I am stuck in copying or linking data in between different sheets.

please help.

please open the file to understand the nature of the problem.

3 Replies

@subhaNew I believe Power Query can fairly easily do what you need. With a slight modification to the data table you can create output similar (though not exactly the same) to what you described in the FOIL tab. See for yourself in the attached file.

Thanks for your help
Riny_van_Eekelen.
let me try it...
Is there any other way to do that ?