( by Frank Bernard )
I am trying to make a spreadsheet in Google spreadsheet and I have an idea I am trying to do, but have no idea how to do it.
I have attached two screenshots to this question to give a better idea of what I am trying to ask. So I want to take the RAW info in pic SS1 to different tables in SS2.
So there is a row in SS1 that says gas with some info. Is there a way by just copying and pasting data to that RAW sheet where it would automatically take data and organize it in to the according table.
So for example the gas row I would like that to go in to the table. I would like everything to transfer over the way it is except the gas part. Now I wonder if this is even possible.
I am pretty good at creating spread sheets, but this would be way beyond anything I have ever tried, and I don't know if this is even possible.
So I guess my question is, is it possible, and if so, how can it be done? If it is not possible I would love to stop wasting my time on it and approach this a completely different way.
Thanks in advance for any help.
And similarly we can put the filter formulas in all the tables of different categories.