I've got a task in Excel I'm trying to figure out how to do.
We use a specialized software to track client interactions; it has very limited baked in reporting abilities, but mostly to get real reports you have to export CVS data and dump it into Excel.
The problem I'm having is two fold; the way it exports cilent request is wonky as hell. If they're different enough, they split up the interaction into two lines with the same interaction ID, but if they're similar they group them together (think, widget A and widget B and widget C) and they all wind up on the same cell in Excel. Compounding this, if the software groups those request that way, it lumps another piece of data (let's call it the suppliers) all together, as CSV, in the same cell in Excel.
So for example,
[Widget A, Widget B, Widget C] would be in one cell, there'd be a few columns with other data (client locations, size, etc), then another cell with [Supplier A, B, C].
It's easy enough to just do a Text to Columns and dump them all into a new column but then formatting gets wonky as hell; I could theoretically manually transpose everything and get them back into new rows to make pivots easier, but this spreadsheet is closing in on 100k rows, and I'm concerned about screwing up formatting and taking forever. Plus I'd like to be able to check on this more often.
My hands are tied with our software unfortunately.