Experts:
Good morning -- I need some assistance with a, e.g., Crosstab/Transform query which transposed AND slightly re-arranges a table automatically.
Attached DB contains 2 tables:
1. Table [01_tbl_SampleRecords] -- this is my source table that needs to be transposed/re-arranged.
2. Table [02_tbl_SampleRecords_Transposed] -- this is merely a depiction as to how the query's output should look like upon execution.
Process:
- To better illustrated the transpose/re-arrange process, I have included a spreadsheet which summarizes the "3-step" process.
Note:
- As indicated in the XLSX, please keep in mind that field [ID] is stored as data type = "text" (vs. number).
Does anyone have recommendations for creating a, e.g., crosstab query which automatically outputs what is depicted in step 3 (aka see JPG & 2nd table in the DB)?
Thank you,
Tom
P.S. In my actual table, I do have approximately fifty (50) fields that will have to be turned from fields into records. Same process applies though (instead of turning {CITY, STATE, ZIP} into rows, it will be those 3 + another ~47 fields.
P.S.S. If a crosstab won't be able to accomplish it, I'd be ok using VBA (if necessary).