I need my columns with data pivoted and also have a title column adjacent populated with “column names” for reference.
I did achieve a bit of it but the Do loop is not working for me. You can see it in my attached sample.
This is my data table:
Expand|Select|Wrap|Line Numbers
- tblData
- id FName LName NumofCars NumofBikes NumofVans TotalCount
- 1 James Philman 2 0 1 3
- 2 Robery KINSEY 1 1 2 4
Expand|Select|Wrap|Line Numbers
- tblResult
- id Title ItemCount
- 1 NumofVans 1
- 1 NumofBikes 0
- 1 NumofCars 2
- 2 NumofVans 2
- 2 NumofBikes 1
- 2 NumofCars 1
1. In the result set some of the columns are skipped during pivot like Fname, LName, TotalCount.
2. I also need the item count to be “Numeric field”. When I change it in my table I get an error during run time.
I really appreciate any help I can get with this. Thanks in advance.
JJ