Recording and recovering metadata in a table
I have a stacked data table with three columns that contain strings and another numeric. A: unique identifierB: textC: text As, Bs, Cs, Values-----A1, B1, C1, value11A1, B1, C1, value12A1, B1, C1, value13A2, B2, C2, value21A2, B2, C2, value22A2, B2, C2, value23 Right now, I am creating a concatenated column name with the form "A (B) [C]" which I split to have the final table like so: A1 (B1) [C1]...