HELP!!how to display data from jumped multiple sheet_1 columns(e.g. column a&d&g...) in sheet_2

%3CLINGO-SUB%20id%3D%22lingo-sub-1391009%22%20slang%3D%22en-US%22%3ERe%3A%20HELP!!%5BFresh%20New%5Dhow%20to%20display%20data%20from%20jumped%20multiple%20sheet_1%20columns(e.g.%20a%26amp%3Bd%26amp%3Bg...)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1391009%22%20slang%3D%22en-US%22%3E%3CP%3Eit's%20just%20like%3CBR%20%2F%3E%3CBR%20%2F%3Esheet1%3A%3CBR%20%2F%3Einvoice%7C%20job%7C%20details%20of%20charges%7C%20revenue%7C%20outlay%7C%20details%20of%20charges%7C%20revenue%7C%20outlay%7C%20details%20of%20charges%7C%20revenue%7C%20outlay%3CBR%20%2F%3E...%7C%20...%7C%20...%20%7C...%20%7C......%20%7C...%20%7C......%20%7C...%20%7C...%3CBR%20%2F%3E...%7C%20...%7C%20...%20%7C...%20%7C......%20%7C...%20%7C......%20%7C...%20%7C...%3C%2FP%3E%3CP%3E...%7C%20...%7C%20...%20%7C...%20%7C......%20%7C...%20%7C......%20%7C...%20%7C...%3CBR%20%2F%3E%3CBR%20%2F%3Esheet2%3A%3CBR%20%2F%3Ejob%20...%3CBR%20%2F%3E%3CBR%20%2F%3Edetails%20of%20charges%7C%20revenue%7C%20outlay%3CBR%20%2F%3E...%20%7C...%20%7C...%3CBR%20%2F%3E...%20%7C...%20%7C...%3CBR%20%2F%3E...%20%7C...%20%7C...%3CBR%20%2F%3E%3CBR%20%2F%3Ethe%20data%20are%20just%20there%2C%20but%20i%20have%20no%20idea%20of%20how%20i%20can%20get%20them%20in%20order%20in%20this%20way(from%20column%20c%2C%20f%2C%20i%2C%20l...etc)%20and%20list%20out.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1391004%22%20slang%3D%22en-US%22%3EHELP!!how%20to%20display%20data%20from%20jumped%20multiple%20sheet_1%20columns(e.g.%20column%20a%26amp%3Bd%26amp%3Bg...)%20in%20sheet_2%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1391004%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHi%20all%2C%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EI'm%20asked%20to%20do%20a%202-sheets%20excel%20for%20my%20aunt%2C%20in%20which%20sheet_1%20store%20all%20the%20data%20and%20sheet_2%20display%20the%20data%20controlling%20by%20the%20Drop-down%20list.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3ECurrently%20I'm%20facing%20an%20issue%2C%20as%20my%20aunt%20want%20the%20data%20store%20in%20sheet_1%20in%20specific%20format%20(invoice%7C%20job%7C%20details%20of%20charges%7C%20revenue%7C%20outlay%7C%20details%20of%20charges%7C%20revenue%7C%20outlay%7C%20details%20of%20charges%7C%20revenue%7C%20outlay...etc)%2C%20I%20cant%20do%20it%20easily%20in%20way%20of%20define%20and%20name%20and%20V%20LOOKUP%26nbsp%3Bthem.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EI'm%20new%20to%20excel%20and%20the%20forum%2C%20I%20have%20no%20idea%20of%20how%20to%20do%20this.%20Please%20can%20anyone%20help%3F%20I'd%20upload%20the%20photos%20with%20an%20ideal%20output%20example%20in%20sheet_3%20using%20the%20first%20as%20standard.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EThanks%20a%20lot!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1391004%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20mobile%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Contributor

Hi all,

I'm asked to do a 2-sheets excel for my aunt, in which sheet_1 store all the data and sheet_2 display the data controlling by the Drop-down list.

Currently I'm facing an issue, as my aunt want the data store in sheet_1 in specific format (invoice| job| details of charges| revenue| outlay| details of charges| revenue| outlay| details of charges| revenue| outlay...etc), I cant do it easily in way of define and name and V LOOKUP them.

I'm new to excel and the forum, I have no idea of how to do this. Please can anyone help? I'd upload the photos with an ideal output example in sheet_3 using the first as standard.

Thanks a lot!

1 Reply
Highlighted

it's just like

sheet1:
invoice| job| details of charges| revenue| outlay| details of charges| revenue| outlay| details of charges| revenue| outlay
...| ...| ... |... |...... |... |...... |... |...
...| ...| ... |... |...... |... |...... |... |...

...| ...| ... |... |...... |... |...... |... |...

sheet2:
job ...

details of charges| revenue| outlay
... |... |...
... |... |...
... |... |...

the data are just there, but i have no idea of how i can get them in order in this way(from column c, f, i, l...etc) and list out.