With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Wednesday, July 23, 2014
yogi_Merge Data From Sheets Named 'ATC' And 'Users' With Different Field Configurations Into A Single Sheet With Common Field Configuration
Google Spreadsheet Post #1706 Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MIwww.energyefficientbuild.com. Jul-23-2014 post by:archiewood : (https://productforums.google.com/forum/#!mydiscussions/docs/XgjyZPElVzk) Combining pages into a single sheet
I've got a sheet with three pages, two of which are populated by (separate) forms. Both forms collect information about the same thing, but one collects less than the other. Form B's fields are all also contained in Form A, but not vice versa.
I would like to be able to combine the two sets of results into one sheet.
Table1: A B C1David32 M2Tom24 M3Sarah27 FTable2: A B1Alan32 2Suzi25 3Claire31 Table3: A B C1David32 M2Tom24 M3Sarah27 F4Alan32 5Suzi25 6Claire31
Table 3 above is the target. Is this possible?
Hi Ivanna, thanks for the effort you're making trying to help me. I clearly haven't effectively communicated the problem to begin with, so I'll try again.
The problem isn't just that the two sheets have different numbers of columns, but that the columns that do match are in a different order. My example did not reflect this. This is the first few columns from the actual sheets:
Sheet ATC: Timestamp|Callsign(if applicable)|Aircraft registration |Aircraft type |Type of flight SheetUsers: Timestamp|Captain|Aircraftoperator|Callsign(if applicable)|Aircraft registration
There is some commonality between the two, but this out-of-step order is typical of the whole thing. Clearly if I just lump the rows of ATC and Users together, the result will be a meaningless mess.
Presenting it this way makes me think it was ridiculous to even ask whether a formula could reorganise these with any efficiency. I think the best thing is to use one of your earlier formulas, and just put blocking columns in the 'smaller' sheet so that the columns will line up once they're combined?