SpreadEveryone: The Fetchland Excel wire

98 watchers

kstuart Oct 2021 11:23am, 2 Oct 2021 4,352 posts	0 kstuart Hmm if i am bored next week i may have a play with that see how well it goes.
GregP Oct 2021 11:59am, 2 Oct 2021 129,779 posts	0 GregP The shortcut was for filter AA - merged cells play hob with filters. Alt-D-F-F also does the same thing
Tazsedai Oct 2021 12:47pm, 2 Oct 2021 937 posts	0 Tazsedai Is there a shortcut for centre across columns?
SPR Oct 2021 1:04pm, 2 Oct 2021 35,331 posts	0 SPR I don't generally do shortcuts so someone else will have to answer that.
um Oct 2021 1:56pm, 2 Oct 2021 5,229 posts	0 um I don't know a shortcut, but you could record a macro (select cells, then record from there).. Or write a bit of code as an add-in, with button, eg thespreadsheetguru.com
JCB Oct 2021 2:03pm, 2 Oct 2021 2,616 posts	0 JCB Thanks GregP, that’s ringing a bell now. Is there an equivalent in google sheets? I’ll probably forget before I get to use it.
Tazsedai Oct 2021 3:09pm, 2 Oct 2021 938 posts	0 Tazsedai Thanks um, that looks like a useful site.
larkim Oct 2021 3:17pm, 7 Oct 2021 15,671 posts	0 larkim I've got two sheets of data which have the same structure and I'd like to be able to easily present core elements and summaries from them side by side without having to tinker with either of them or merge them together into one data source (if possible). e.g. both sheets are Employee ID / Employee Name / Employee FTE / Employee Role and sheet 1 is budget full year, sheet 2 is september actual. It's a doc which will need some manual review so I'm thinking something like this (which will look terrible on fetch) Annual budget Sept actual Role Name FTE Role Name FTE Tech1 Joe Bloggs 1.0 Tech 1 Joe Bloggs 1.0 Tech2 Jane Bloggs 0.5 Tech2 Jane Bloggs 0.25 Tech2 Vacant 0.25 Tech 3 Vacant 1.0 Tech3 Fred Bloggs 1.0 Tech 4 Max Bloggs 0.5 Tech 4 Max Bloggs 1.0 Tech 4 Max Bloggs 0.5 etc etc Any easy new part of Excel which fits the bill? It feels like two pivot tables merged somehow
SPR Oct 2021 4:29pm, 7 Oct 2021 35,407 posts	0 SPR You can use a data model to make one pivot if you have a common link that is unique in at least one tab. Not something I'm an expert on but should be fairly easy to set up based on the data structure you describe.
larkim Oct 2021 4:38pm, 7 Oct 2021 15,672 posts	0 larkim Pivot table is one way but it doesn't quite fit the bill somehow. I want both sets of data to show (in that example) the 3 relevant columns and where there's no match to have a blank line, so end up with 6 columns. Pivot table I think insists on using one row on the left hand side which combines both tables into that row. I can work with a pivot table, and if I was doing it in access I'd be able to craft a report which did it I think, but I can't think of an easy Excel way to make it happen.