• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Combining multiple columns of data into one column

J

jcalvacca

Member
Hello all and thanks in advance. File attached with the original layout and the desired final column.


-Original data will always be laid out as such with Date, sample1,sample2,sample3
-There will be blanks in the data that should be eliminated.
-Will be used later on in sheet for charting a scatter plot.

Thanks in advance for the assistance!!

-Jerry
 

Attachments

  • Jerry1.xlsx
    10.8 KB · Views: 5
vletm said:
@jcalvacca
Something like this...
press [Do it]
Click to expand...
@vletm

Really nice!

Attached is my real one that I am working on....
I included a note page so you understand my logic of where things are coming from...

I'm sorry, I'm terrible when it comes to macros but I know that is an area where I need to get better.

Thanks for all of the assistance again!!!
 

Attachments

  • vletm_QA File Project.2.16.xlsx
    781.4 KB · Views: 3
@jcalvacca
Have You checked Your 'Notes'?
There are something that You should modify.
Like: '-700 and -70' ... I haven't found those so far.
You should add there some sample values and wanted result.
That is connection with this and 'Jerry1'?
You should try to 'open Your vision as clear as possible'!
... and 'REF Charts' ... that is really full of #REF!s,
do You really need all of those 'errors'?
 
vletm said:
@jcalvacca
Have You checked Your 'Notes'?
There are something that You should modify.
Like: '-700 and -70' ... I haven't found those so far.
You should add there some sample values and wanted result.
That is connection with this and 'Jerry1'?
You should try to 'open Your vision as clear as possible'!
... and 'REF Charts' ... that is really full of #REF!s,
do You really need all of those 'errors'?
Click to expand...

@vletm

Good gawd......sorry about that. i'll get something better shortly :)
 
vletm said:
@jcalvacca
Have You checked Your 'Notes'?
There are something that You should modify.
Like: '-700 and -70' ... I haven't found those so far.
You should add there some sample values and wanted result.
That is connection with this and 'Jerry1'?
You should try to 'open Your vision as clear as possible'!
... and 'REF Charts' ... that is really full of #REF!s,
do You really need all of those 'errors'?
Click to expand...
@vletm

Ok try this one please....thank u
 

Attachments

  • vletm_QA File Project.2.16.1.xlsx
    795.6 KB · Views: 3
@jcalvacca
Why do You have so many same formulas in 'REF Charts'?
If Your 'vision' to get some values from '-72' to 'REF Chart' ... NO WAY!
Why do You have many times 6-packets? ( B:AD is 1st packet )
Do You want to see information from all sheets (-700 ... -77) or from only one?
If only ONE then You'll need only ONE 6-packet.
If more ... You gotta have very very wide monitor!
I cannot still get any connection with 'Jerry1' ... but gotta go on...
The 1st thing is to add more necessary data to sheets (-700...'77)
The 2nd thing is to write manually wanted output to 'REF Chart'!
The 3rd thing is to delete ALL those if-formulas!
What is function of 'Charts'-sheet? ... only selection?
>> Ideas ... Questions?
 
@vletm

Thanks for the help

Charts page is solely for selection and viewing of charts, nothing more....

I deleted many tabs because the file was too big to upload so perhaps there were things that were unclear on there...

Charts may be data from one tab (-72), or data from all tabs, depending on user selection BUT all data will be coming from the same columns regardless of page....see -72 for where they will come from.

Everyone has dual monitors here :)

I'm very overwhelmed with this project as I don't know what the end will look like.
 
@jcalvacca
You can select only one sheet like '-72' to see to 'REF Charts'.
=> You need only 'one 6-packet' = B:AD
Is 'REF Charts'-layout now something like Your vision?
Okay, dual monitors ... one monitor one sheet ... 10 employee => 20 sheets.
That needs big round room and everyone sits in the center of room (Doughnut).
Try to think ... my option (vision).
 

Attachments

  • vletm_QA File Project.2.16.1.xlsx
    643.9 KB · Views: 1
@vletm

Closer.....

This 6 packet needs then to change dynamically to take in the choices of the Charts tab.

Will need to chart just "ebco" or "vendor" or "both"......

Also one of my charts will take data from ALL sheets, how would a single packet handle something like that if its all sheets (look at "Entry Form" sheet to see how many final project will be.

Thanks for the help again!
 
@jcalvacca
Check 'REF Charts'-sheet.
You could see All/Ebco/Vendor -number this way too! (orange area could delete)
Only have to learn to read!
You can filter those 'All/Ebco/Vendor' with 'Cell D2'
And same way it's possible to do with all other sheets (those needs minor mod).
>> Ideas ... Questions?
 

Attachments

  • vletm_QA File Project.2.16.1.xlsx
    636.5 KB · Views: 3
vletm said:
@jcalvacca
Check 'REF Charts'-sheet.
You could see All/Ebco/Vendor -number this way too! (orange area could delete)
Only have to learn to read!
You can filter those 'All/Ebco/Vendor' with 'Cell D2'
And same way it's possible to do with all other sheets (those needs minor mod).
>> Ideas ... Questions?
Click to expand...

@vletm

As far as user, they will use the individual tabs to put in data (-70,-71,-72,etc)
They will also use the ending "Charts" to review.....

All the rest of the tabs is "behind the scenes" stuff.....so REF Charts is a behind the scenes sheet that gets the data ready for charting...user will never go in to pick any choices off of a pivot table.

Not sure if this will be useful (and automated requiring no clicking) on user's behalf.

Maybe this can be used on the Charts page to get the data from the part tabs (-70,-71,-72,etc)??

User will use the top of "Charts" sheet to select what they want to see chart automatically.
 
You must log in or register to reply here.
Back
Top